by Seal （Haibo Yu）2008-7-20
1>將mysql安裝文件(本人使用mysql5.0.51a-linux-i686-glibc23.tar.gz)解壓到對應目錄，在此為 /home/seal/mysql
2>進入源碼目錄編譯安裝
CODE:
#cd /home/seal/mysql
#./configure --prefix=/usr/local/mysql --with-charset=gbk |注:配置Mysql安裝路徑并且支持中文
#make |注:編譯
#make install |注:編譯安裝
3>替換/etc/my.cnf文件,進入源碼包,執行命令
CODE:
#cd /home/seal/mysql
#cp support-files/my-medium.cnf /etc/my.cnf
4>建立MySQL使用者和群組:
CODE:
#groupadd mysql
#useradd -g mysql mysql
5>完成以上操作以后進行初始化數據庫,進入已經安裝好的mysql目錄
CODE:
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql |注:--user=mysql 初始化表并且規定用mysql用戶
6>設置給mysql和root用戶設定訪問權限 我們先進入mysql目錄
CODE:
#cd /usr/local/mysql
#chown -R root /usr/local/mysql |注:設定root能訪問/usr/local/mysq
#chown -R mysql /usr/local/mysql/var |注:設定mysql用戶能訪問/usr/local/mysql/var
#chgrp -R mysql /usr/local/mysql |注:設定mysql組能夠訪問/usr/local/mysq
7>啟動mysql,進入已經安裝好的目錄
CODE:
#cd /usr/local/mysql
#bin/mysqld_safe --user=mysql &
8>
修改mysql數據庫超級用戶root的缺省密碼:
/usr/local/mysql/bin/mysqladmin -u root password 'mysql'
關閉mysql服務器
cd /usr/local/mysql/bin
./mysqladmin -u root -p shutdown
9>設定開機就啟動mysql,進入源碼目錄下
# cd /home/seal/mysql
# cp support-files/mysql.server /etc/init.d/mysql
# chmod +x /etc/init.d/mysql
# chkconfig --level 345 mysql on
# service mysql restart
Shutting down MySQL. [ 確定 ]
Starting MySQL [ 確定 ]
[root@localhost mysql]#
10>設置Mysql遠程訪問：
在啟動mysql后：
mysql>
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@'%’ IDENTIFIED BY ‘mypassword’ WI
TH GRANT OPTION;
mysql>Flush Privileges;
安裝完畢。