1. 下载安装MySQL的库
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2. 下载完成后使用yum进行安装
yum -y install mysql57-community-release-el7-10.noarch.rpm
3. 更新MySQL的公钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
4. 安装MySQL的服务器
yum -y install mysql-community-server
5. 安装完成后,启动MySQL服务
systemctl start mysqld
6. 查看MySQL的状态
systemctl status mysqld.service
7. 过滤出MySQL的原始登录密码
grep "password" /var/log/mysqld.log
8. 登录数据库(输入过滤出来的密码,如上图:no;Eq5>>al)
mysql -u root -p
9. 进入MySQL后更改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123qwe!@#QWE';
10. 开启MySQL的远程访问(%代表所有的IP都能访问)
11. grant all privileges on *.* to 'root'@'%' identified by '123qwe!@#QWE' with grant option;
12. 刷新保存
13. flush privileges;
14. 退出MySQL
exit