centos7 RPM方式安装MySQL5.6
a) 查看centos版本
cat /etc/redhat-release
b) 卸载MariaDB （centos7默认自带）
查看当前安装的mariadb包： rpm -qa | grep mariadb
强制卸载： rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
c) 查看是否已经安装了MySQL
rpm -qa | grep -i mysql
find / -name mysql
删除分散mysql文件
find / -name mysql / # whereis mysql
删除配置文档
rm -rf /etc/my.cnf
再次查找机器是否安装mysql
rpm -qa|grep -i mysql
d) 安装MySQL
cd /data/soft/MySQL-5.6.36-1.el7.x86_64.rpm-bundle
ls
MySQL-client-5.6.36-1.el7.x86_64.rpm MySQL-server-5.6.36-1.el7.x86_64.rpm
MySQL-devel-5.6.36-1.el7.x86_64.rpm
rpm -ivh MySQL-server-5.6.36-1.el7.x86_64.rpm
rpm -ivh MySQL-devel-5.6.36-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.36-1.el7.x86_64.rpm
或者：rpm -ivh MySQL-*.rpm
#修改配置文件位置
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
e)初始化MySQL及设置密码
/usr/bin/mysql_install_db
service mysql start
cat /root/.mysql_secret #查看root账号密码
# The random password set for the root user at Wed Dec 11 23:32:50 2013 (local time): qKTaFZnl
mysql -u root –pqKTaFZnl
mysql> SET PASSWORD = PASSWORD('123456'); #设置密码为123456
mysql> exit
mysql -uroot -p123456
f)远程登陆用户设置
mysql> use mysql;
mysql> select host,user,password from user;
+-----------------------+------+-------------------------------------------+
| host | user | password |
+-----------------------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
| 127.0.0.1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
| ::1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
+-----------------------+------+-------------------------------------------+
mysql> update user set password=password('123456') where user='root';
mysql> update user set host='%' where user='root' and host='localhost';
mysql> flush privileges;
mysql> exit
g)设置开机自启动
chkconfig mysql on
chkconfig --list | grep mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
h)修改字符集和数据存储路径
配置/etc/my.cnf文件,修改数据存放路径
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
max_connections=3000
event_scheduler=ON
[mysql]
default-character-set = utf8
参考：
http://www.centoscn.com/mysql/2015/0624/5729.html
http://www.2cto.com/kf/201609/550880.html
常见错误：
sql执行错误#1018:can't read dir of './performance_schema/'(errno:13-permission denied)
ls -ld /var/lib/mysql/performance_schema
chown -R mysql:mysql /var/lib/mysql/performance_schema
http://blog.csdn.net/thinkpadshi/article/details/48650921
