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