# 更新密钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

# 安装 MySQL Yum 仓库
rpm -Uvh http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm

yum -y install mysql-community-server

systemctl start mysqld
systemctl enable mysqld

cat /var/log/mysqld.log | grep "temporary password"

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';  -- 密码需要符合：大于8位，有大写字母，有特殊符号

set global validate_password_policy=LOW;  -- 密码安全级别低
set global validate_password_length=4;     -- 密码长度最低4位即可
ALTER USER 'root'@'localhost' IDENTIFIED BY '简单密码';

grant all privileges on *.* to root@"IP地址" identified by '密码' with grant option;  
flush privileges;

SET GLOBAL validate_password_length = 4;
SET GLOBAL validate_password_mixed_case_count = 1;
SET GLOBAL validate_password_number_count = 0;
SET GLOBAL validate_password_special_char_count = 0;
SET GLOBAL validate_password_policy = LOW;
FLUSH PRIVILEGES;

CREATE USER 'chess'@'localhost' IDENTIFIED BY '密码';

GRANT ALL PRIVILEGES ON *.* TO 'chess'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;