centos7安装并配置mysql（详细版）

1、下载yum源：wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2、安装yum文件：yum localinstall mysql57-community-release-el7-8.noarch.rpm 

选择：y

 3、检查mysql源是否安装成功：yum repolist enabled | grep "mysql.*-community.*"

4、安装mysql命令：yum -y install mysql-community-server

注：如出现mysql密钥过期，请参考此篇文章。点击跳转[解决mysql密钥过期问题]Centos7安装MySQL时报错：The GPG keys listed for the “MySQL 5.7 Community Server“_嫣然一笑lmz的博客-CSDN博客

5、启动mysql命令：systemctl start mysqld

6、查找初始密码：grep 'temporary password' /var/log/mysqld.log

 7、使用初始密码登录mysql：mysql -u root -p，输入密码

 8、修改root的密码： ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

提示不符合安全

 9、退出mysql：quit；【先记下初始密码，重新登录时需要使用】

修改密码策略（安全等级low），输入：vim /etc/my.cnf

点击i，进入输入状态，添加：validate_password_policy=0

点击Esc，输入：wq，保存并退出

 10、重新启动mysql：systemctl restart mysqld

11、登录mysql：mysql -u root -p，输入初始密码，重置新密码即可

12、设置权限，允许远程连接（允许root在本地和任意IP下被访问）

grant all privileges on *.* to root@"%" identified by "新密码";

grant all privileges on *.* to root@"localhost" identified by "新密码";

13、刷新权限：flush privileges;