在centos7.2上安装和配置mysql 5.7

1. 在 https://www.mysql.com/downloads/  找到自己需要的包。
    如： wget https://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm 

2. 安装rpm
    rpm -i mysql57-community-release-el7-9.noarch.rpm

3. 更新
    yum update

4. 安装mysql
    yum install mysql-community-server

5. 重启服务
    service mysqld restart

6. 开机启动
    systemctl enable mysqld
    systemctl daemon-reload  

7. 查看默认密码
    grep 'temporary password' /var/log/mysqld.log

8. 修改密码策略
    vi /etc/my.cnf

9. 随意设置密码
    添加一行 validate_password = off

10.重启使配置生效
    systemctl restart mysqld

11.修改密码
    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '******';
    或
    mysql> set password for 'root'@'localhost'=password('******'); 

12.mysql开启远程连接
     mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;

13.防火墙允许远程连接
     firewall-cmd --zone=public --add-port=3306/tcp --permanent
     firewall-cmd --reload