CentOS 6.5 二進位安裝MySQL 5.6

標籤：二進位安裝mysql 5.6

CentOS 6.5 二進位安裝MySQL 5.6

--------------------------------

下載MySQL5.6二進位包

mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz

安裝相關依賴包

yum install libaio*

useradd mysql

安裝mysql到/data/mysql/data下

tar zxvf mysql-5.6.20-linux-glibc2.5-x86_64.tar.gz -C /data/

mv mysql-5.6.20-linux-glibc2.5-x86_64 mysql

修改mysql的各級檔案夾和檔案的建立者、建立組為mysql（注意語句後面有個.）

chown -R mysql.mysql /data/mysql

至此mysql已經安裝完了，

但還需要初始化，初始化mysql表、test表、infomation表等。

/data/mysql/scripts/mysql_install_db --datadir=/data/mysql/data --basedir=/data/mysql --user=mysql --explicit_defaults_for_timestamp

-------------------------------------------------------------------------------------------------------------------------------------

拷貝啟動指令碼

cp /data/mysql/support-files/mysql.server /etc/init.d/mysqld

　

ln -s /data/mysql/include /usr/include/mysql

echo "/data/mysql/lib" > /etc/ld.so.conf.d/mysql.conf && ldconfig -v

ln -s /data/mysql/bin/mysql /usr/bin 

修改設定檔my.cnf

cd /data/mysql

 cp my.cnf /etc/my.cnf

 vim /etc/my.cnf

[mysqld]中添加：

 

basedir = /data/mysql

datadir = /data/mysql/data

port = 3306

server_id = 1

-------------------------　　

啟動mySQL服務

chkconfig mysqld on

service mysqld start

　　

登陸MySQL並且刪除空使用者

mysql

mysql> SELECT user,host,password FROM mysql.user;

+------+-----------------------+----------+

| user | host                  | password |

+------+-----------------------+----------+

| root | localhost             |          |

| root | localhost.localdomain |          |

| root | 127.0.0.1             |          |

| root | ::1                   |          |

|      | localhost             |          |

|      | localhost.localdomain |          |

+------+-----------------------+----------+

6 rows in set (0.00 sec)

 

設定密碼（）括弧裡面的為密碼，使用者名稱root

mysql> UPDATE mysql.user set password = PASSWORD(‘[email protected]‘) WHERE user = ‘root‘;

mysql> SELECT user,host,password FROM mysql.user;

+------+-----------------------+-------------------------------------------+

| user | host                  | password                                  |

+------+-----------------------+-------------------------------------------+

| root | localhost             | *11B9ACA21786F766739D0EB1483C5F64212B81AC |

| root | localhost.localdomain | *11B9ACA21786F766739D0EB1483C5F64212B81AC |

| root | 127.0.0.1             | *11B9ACA21786F766739D0EB1483C5F64212B81AC |

| root | ::1                   | *11B9ACA21786F766739D0EB1483C5F64212B81AC |

|      | localhost             |                                           |

|      | localhost.localdomain |                                           |

+------+-----------------------+-------------------------------------------+

6 rows in set (0.00 sec)

mysql> DROP USER ‘‘@localhost;

 

mysql> FLUSH PRIVILEGES;

mysql> quit

---------------------MySQL安裝完成-------------------------------

設定/修改 密碼

mysql> grant all privileges on *.* to ‘root‘@‘localhost‘ identified by ‘[email protected]‘ with grant option;

mysql> flush privileges;

　　

CentOS 6.5 二進位安裝MySQL 5.6