centos7安装mysql5.6

yum list installed | grep mysql

2、如果发现有系统自带mysql，请卸载

yum -y remove mysql-libs.x86_64

3、下载mysql yum源

 wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

4、配置MySQL的安装源

 rpm -ivh mysql-community-release-el6-5.noarch.rpm

5、安装mysql 服务器命令

yum install mysql-community-server

6、安装成功后启动

 service mysqld start

或者

  systemctl start mysqld

7、设置自启动

systemctl enable mysqld

8、设置密码

mysql_secure_installation  设置为123456

9、登录

mysql -uroot -p123456

10、外部连接
编辑/etc/my.conf,新增

[mysqld]

port=3306

bind-address=0.0.0.0

编辑权限表：

 use mysql;
 select user,host from user;
 update user set host='%' where user='root';（可能报错）
 flush privileges;
# 任意主机以用户root和密码mypwd连接到mysql服务器
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
 flush privileges;
 #IP为192.168.133.128的主机以用户myuser和密码mypwd连接到mysql服务器
 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.133.128' IDENTIFIED BY 'mypwd' WITH GRANT OPTION; 
 flush privileges;