CentOS 6.7下RPM方式安装MySQL5.6.25

1. 下载Linux对应的RPM包，如：CentOS6.7_64对应的RPM包，如下：

-rw-r--r-- 1 root root 23135399 Jun 12 19:31 MySQL-client-5.6.25-1.linux_glibc2.5.x86_64.rpm
-rw-r--r-- 1 root root  4586217 Jun 12 19:31 MySQL-devel-5.6.25-1.linux_glibc2.5.x86_64.rpm
-rw-r--r-- 1 root root 88715219 Jun 12 19:31 MySQL-server-5.6.25-1.linux_glibc2.5.x86_64.rpm

2. 检查MySQL及相关RPM包，是否安装，如果有安装，则移除（rpm –e 名称）

[root@localhost ~]# yum remove mysql mysql-server mysql-libs compat-mysql51

[root@localhost ~]# rpm -qa|grep mysql

3. 安装MySQL

[root@localhost src]# rpm -ivh MySQL-server-5.6.25-1.linux_glibc2.5.x86_64.rpm

[root@localhost src]# rpm -ivh MySQL-devel-5.6.25-1.linux_glibc2.5.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:MySQL-devel            ########################################### [100%]
[root@localhost src]#  rpm -ivh MySQL-client-5.6.25-1.linux_glibc2.5.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]

4. 初始化MySQL及设置密码
[root@localhost src]# /usr/bin/mysql_install_db

[root@localhost src]# service mysql start

[root@localhost src]# cat /root/.mysql_secret

# The random password set for the root user at Mon Jun 12 19:32:56 2017 (local time): OhqSz79wP6GLyend

[root@localhost src]# mysql -uroot -p

Enter password: OhqSz79wP6GLyend

5. 允许远程登陆

mysql> select host,user,password from user;
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| localhost.localdomain | root | *7426C21891806EB62399010080AD988BA9557228 |
| 127.0.0.1             | root | *7426C21891806EB62399010080AD988BA9557228 |
| ::1                   | root | *7426C21891806EB62399010080AD988BA9557228 |
+-----------------------+------+-------------------------------------------+
4 rows in set (0.04 sec)


mysql> update user set host='%' where host='::1';
Query OK, 1 row affected (0.10 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> select host,user,password from user;
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| localhost.localdomain | root | *7426C21891806EB62399010080AD988BA9557228 |
| 127.0.0.1             | root | *7426C21891806EB62399010080AD988BA9557228 |
| %                     | root | *7426C21891806EB62399010080AD988BA9557228 |
+-----------------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

6. 设置开机自启动

[root@localhost src]# chkconfig mysql on
[root@localhost src]# chkconfig --list|grep mysql
mysql           0:off 1:off 2:on 3:on 4:on 5:on 6:off

7.  MySQL的默认安装位置
/var/lib/mysql/               #数据库目录
/usr/share/mysql              #配置文件目录
/usr/bin                     #相关命令目录
/etc/init.d/mysql              #启动脚本

8.  更改MySQL目录与字符集

[root@localhost src]# cd /
[root@localhost /]# mkdir data
[root@localhost /]# service mysql stop
Shutting down MySQL.. SUCCESS! 
[root@localhost /]# mv /var/lib/mysql  /data
[root@localhost /]# mkdir -p /data/mysql/binarylog
[root@localhost /]#  chown -R mysql:mysql /data/mysql

修改mysql配置文件的位置

[root@localhost /]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf'? yes

[root@localhost /]# vim /etc/my.cnf

[client]
password = 123456
port = 3306
default-character-set = utf8
[mysqld]
port = 3306
socket = /data/mysql/mysql.sock
character_set_server = utf8
character_set_client = utf8
collation-server=utf8_general_ci
lower_case_table_names = 1
max_connections = 1000
datadir = /data/mysql/
log_bin = /data/mysql/binarylog/binlog 
[mysql]
default-character-set = utf8
socket  = /data/mysql/mysql.sock 

9.重启mysql

[root@localhost /]# service mysql restart

[root@localhost /]# mysql -uroot -p

查看字符集
show variables like '%collation%';
show variables like '%char%';