二進位方式安裝mysql-5.6.16

標籤：系統版本   use   group   版本   groupadd   ini   所有者   linux   client   

一、檢查系統版本
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)

 

二、添加使用者與組

# groupadd mysql
# useradd -g mysql mysql

 

三、安裝MySQL到/usr/local/mysql下

#cd /usr/local
#tar zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz
#mv mysql-5.6.16-linux-glibc2.5-x86_64/     mysql

 

四、修改mysql目錄的所有者和所屬組位mysql

# chown -R mysql:mysql  mysql/ .

 

五、初始化
#scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 初始化
#cp support-files/mysql.server /etc/init.d/mysqld 

六、修改設定檔
#cp /usr/local/mysql/my.cnf /etc/my.cnf
#vim /etc/my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
server_id = 1
socket = /tmp/mysql.sock

[client]

socket = /tmp/mysql.sock

七、啟動mysql服務
#ln -s /usr/local/mysql/bin/mysql /usr/bin 軟連結
#service mysqld start

八、登陸mysql並且刪除空使用者
mysql> select user,host,password from mysql.user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | mysql | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | mysql | |
+------+-----------+----------+
6 rows in set (0.00 sec)

mysql> UPDATE mysql.user set password = PASSWORD(‘gechong‘) WHERE user = ‘root‘;
mysql> DROP USER ‘‘@localhost;
mysql> FLUSH PRIVILEGES;

二進位方式安裝mysql-5.6.16