linux(centos)下通过yum安装mysql5.6

1. 安装MySQL Yum Repository, 下载地址http://dev.mysql.com/downloads/repo/yum/
shell> sudo yum localinstall mysql-community-release-el6-5.noarch.rpm

2.查看可安装的mysql版本
shell> yum repolist all | grep mysql

3.选择要安装版本, 比如mysql 5.6, 修改/etc/yum.repos.d/mysql-community.repo文件, 设置mysql 5.6下的enabled=1

4.再次查看可安装的版本
shell> yum repolist enabled | grep mysql

5. 安装过程可能出现镜像服务器连接失败, 重新执行安装命令即可
shell> sudo yum install mysql-community-server

6.启动
sudo service mysqld start

7.配置文件放在了 /etc/mysql/my.cnf, 启动服务,关闭服务及重启脚本在  /etc/init.d/mysql

8.设置远程主机登录

INSERT INTO `user` VALUES ('%','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',

'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','','N')

flush privileges;刷新

官方文档

https://dev.mysql.com/doc/refman/5.6/en/installing.html