cenos7安装MySQL

下载 
1、

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

2、

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

3、

sudo yum install mysql-server

4、登陆mysql

5、service mysqld start 启动

6、设置远程连接

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "你的密码";

7、打开防火墙

 firewall-cmd --zone=public --add-port=3306/tcp --permanent 

    7.1  启动防火墙

systemctl start firewalld

8、刷新

firewall-cmd --reload

9、mysql 创建用户远程登陆
    

insert into mysql.user(Host,User,Password) values("%","用户名称",password("密码"));
    GRANT USAGE ON yhxx.* TO '用户名称'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;