Linux下mysql安裝配置總計： 
MySQL安裝配置

本例以root權(quán)限安裝mysql數(shù)據(jù)庫，mysql-5.1.37-linux-x86_64-glibc23.tar.gz安裝包在/root/Nagios/ 目錄下(根據(jù)實(shí)際情況)。

ü     在mysql-5.1.37-linux-x86_64-glibc23.tar.gz安裝包所在目錄，解壓軟件包

cd /root/Nagios/

tar -zvxf mysql-5.1.37-linux-x86_64-glibc23.tar.gz

ü     將解壓的mysql文件夾，移到/usr/local/目錄下

mv mysql-5.1.37-linux-x86_64-glibc23 /usr/local/mysql

ü     將mysql配置文件拷貝到/etc/目錄下，并改名my.cnf

cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

ü 添加mysql用戶及用戶組，用來運(yùn)行mysql數(shù)據(jù)庫

groupadd mysql

useradd -g mysql mysql

ü 修改mysql目錄權(quán)限

// 設(shè)定root能訪問/usr/local/mysql

chown -R root /usr/local/mysql                                                                                  

// 設(shè)定mysql組能訪問/usr/local/mysql

chgrp -R mysql /usr/local/mysql                                                                                 

// 設(shè)定mysql用戶能夠訪問/var/lib/mysql

chown -R mysql /usr/local/mysql/data

ü 在mysql解壓目錄下，生成mysql系統(tǒng)數(shù)據(jù)庫，本例安裝在/usr/local/mysql目錄下

cd /usr/local/mysql                                                                                                   

./scripts/mysql_install_db --user=mysql&                                                                    

ü 以mysql用戶啟動mysql服務(wù)

/usr/local/mysql/bin/mysqld_safe -user=mysql&

ü 修改mysql的root密碼，密碼假定為：123456

/usr/local/mysql/bin/mysqladmin -u root password 123456

ü 進(jìn)入MYSQL安裝路徑下的bin目錄，以root用戶登錄mysql:

cd /usr/local/mysql/bin                                                                                       

./mysql -u root -p                                                                                                    

輸入密碼：123456

ü 開啟 mysql 本地和遠(yuǎn)程訪問

grant all on *.* to root@本機(jī)ＩＰ

grant all privileges on *.* to root @"%" identified by "123456";

flush privileges;

說明：

grant all privileges on *.* to username @"%" identified by "password";

all指定相關(guān)操作

*.*說明數(shù)據(jù)庫和表名

username表示用戶名

%這里是Host名稱，允許所有的就用%

Password表示密碼

  設(shè)置MySQL服務(wù)及命令

拷貝mysql安裝目錄下bin/目錄中的文件到/usr/bin目錄，使mysq等命令可以在任一路徑執(zhí)行:

cp /usr/local/mysql/bin /usr/bin

設(shè)置mysql啟動命令，打開/usr/local/mysql/support-files/mysql.server文件，將以下內(nèi)容：

$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file &

改為：

$bindir/safe_mysqld --datadir=$datadir --user=root --pid-file=$pid_file &

       拷貝到/etc/init.d目錄，并賦可執(zhí)行權(quán)限

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql

       以root用戶調(diào)用以下命令啟動mysql服務(wù)

service mysql start

       設(shè)置mysql自啟動

在文件/etc/rc.d/rc.local中添加

service mysql start