-1.MySQL GPG 密鑰已過期,更新
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
0.清除 mysql 殘留日志,不清除就不能完成第五步,生成新的 mysql 臨時(shí)密碼
rm -rf /var/log/mysqld.log
1.下載 rpm 包
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.安裝 rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
3.安裝 mysql
yum -y install mysql-community-server
4.啟動 mysql 服務(wù)
systemctl start mysqld.service
5.查看臨時(shí)密碼
grep "password" /var/log/mysqld.log
6.登錄 mysql,輸入剛獲取到的臨時(shí)密碼
mysql -uroot -p
7.設(shè)置密碼安全等級最低,可設(shè)置任意字符(可選)
set global validate_password_policy=0;
8.設(shè)置密碼長度不限,可設(shè)置任意長度(可選)
set global validate_password_length=1;
9.修改mysql密碼
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的新密碼';
10.開啟mysql遠(yuǎn)程連接
use mysql;
select host from user where user='root';
update user set host = '%' where user ='root';
flush privileges;