下载rpm

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

安装

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

 yum -y install mysql-server

启动，查询状态，开机自启

systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld

查询密码

grep 'temporary password' /var/log/mysqld.log

登录修改密码

mysql -uroot -p

查询密码规则:

SHOW VARIABLES LIKE 'validate_password%';

降低密码规程:

先将密码安全等级设置为最低
set global validate_password_policy=0;--表示将密码安全等级设置为low
set global validate_password_length=6;--表示将密码长度设置为最小6位

修改密码:

alter user user() identified by "123456";

开启远程访问:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新配置
FLUSH PRIVILEGES;