1. 安装镜像源
yum -y install http://repo.mysql.com/mysql57-community-release-el7.rpm
yum -y install http://repo.mysql.com/mysql80-community-release-el7.rpm
yum -y install http://repo.mysql.com/mysql80-community-release-el8.rpm
2. 查看已安装源
ll /etc/yum.repos.d/
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/5b96252b0d130df7f3e22d779e5c2f3b.png)
搜索Mysql版本
yum --showduplicates list mysql-community-server --nogpgcheck
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/1feb35f4dd72fe1019c09e19ca7a367d.png)
4 安装
4.1 安装指定版本
yum -y install mysql-community-server-5.7.25-1.el7 --nogpgcheck
4.2 安装最新版本
yum -y install mysql-community-server --nogpgcheck
5. 启动
systemctl start mysqld
systemctl enable mysqld
6. 查看历史密码
grep 'temporary password' /var/log/mysqld.log
7. 连接
mysql -u root -p
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/a6ef2bd19fb1c0a7b3d353a36a95abd2.png)
8. 修改密码强度
8.1 mysql5.7
set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=0;
set global validate_password_special_char_count=0;
set global validate_password_length=4;
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/8584e2cb452c0276ccb52a54aaabbb5a.png)
8.2 mysql8.0
set global validate_password.policy=0;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.special_char_count=0;
set global validate_password.length=4;
9. 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
10. 授权远程连接
RENAME USER `root`@`localhost` TO `root`@`%`;
flush privileges;
开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-all