yum 安装 mysql5.7

配置yum源：

yum -y localinstall  http://file.job520.net/linux/yum-repository/mysql.repo.rpm
yum repolist enabled | grep "mysql.*-community.*"
# https://dev.mysql.com/downloads/repo/yum/
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

安装：

yum -y install mysql-community-server
yum -y install mysql-community-devel

设置免密登录：
vim /etc/my.cnf

# 添加该配置
skip-grant-tables

启动服务：
systemctl start mysqld

登录：
mysql

修改密码：
UPDATE mysql.user SET authentication_string=PASSWORD("123456") WHERE user="root";

退出：
quit

移除免密登录：
vim /etc/my.cnf

# 移除该配置
skip-grant-tables

重启：
systemctl restart mysqld

输入密码登录：
mysql -uroot -p123456

修改密码：

SET GLOBAL validate_password_policy=0;
SET GLOBAL validate_password_mixed_case_count=0;
SET GLOBAL validate_password_number_count=3;
SET GLOBAL validate_password_special_char_count=0;
SET GLOBAL validate_password_length=3;
Alter USER 'root'@'localhost' IDENTIFIED BY '123456';

添加远程访问用户：
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '123456';

设置添加用户的授权权限：
UPDATE mysql.user SET Grant_priv='Y' WHERE Host='%';

移除匿名用户：
DELETE FROM mysql.user WHERE Host<>'%' OR User<>'root';