1. 第一步:下载MySQLYum Repository
    2. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
    3. 第二步:安装YumRepository
    4. yum -y install mysql57-community-release-el7-10.noarch.rpm
    5. 第三步:安装MySQL
    6. yum -y install mysql-community-server
    7. 第四步:启动MySQL服务
    8. systemctl start mysqld.service
    9. 第五步:获取MySQL密码
    10. grep "password" /var/log/mysqld.log
    11. 第六步:更新MySQL登录密码
    12. ALTER USER 'root'@'localhost' IDENTIFIED BY '';
    13. 第七步:设置密码的验证强度等级
    14. set global validate_password_policy=LOW;
    15. 第八步:设置密码长度
    16. set global validate_password_length=6;
    17. 第九步:重新设置MySQL密码
    18. ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
    19. 第十步:设置MySQL远程访问
    20. grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
    21. flush privileges;
    22. 第十一步:防火墙添加MySQL端口
    23. firewall-cmd --zone=public --add-port=3306/tcp --permanent;
    24. firewall-cmd --reload
    25. 第十二步:设置数据库字符编码(vim /etc/my.cnf)
    26. [client]
    27. default-character-set=utf8
    28. # For advice on how to change settings please see
    29. # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    30. datadir=/var/lib/mysql
    31. socket=/var/lib/mysql/mysql.sock
    32. character-set-server=utf8
    33. collation-server=utf8_general_ci
    34. service mysqld restart
    35. status