centos7 安装 mysql

1，下载并安装MySQL官方的 Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2，直接yum安装 MySQL服务器

yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

3，启动MySQL服务

systemctl start mysqld.service

4，查看MySql状态

systemctl status mysqld.service

5，查看MySql初始密码

grep “password” /var/log/mysqld.log

6，使用root用户进入Mysql

mysql -u root -p

7，个性密码策略

set global validate_password_policy=0; #密码强度策略设为最低 
set global validate_password_length=6; #密码允许最小长度为6 

8，设置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 
flush privileges; 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
exit;

完成

如果还出现 “Access denied for user ‘root’@‘localhost’ (using password: YES)” 错误。执行以下操作
更新Mysql配置文件

vim /etc/my.cnf

在最后加入这句

skip-grant-tables  

service mysqld reload
mysql -uroot -p

 use mysql;
 UPDATE user SET authentication_string = password ( '123456' ) WHERE User = 'root';
 flush privileges;
 quit;

然后把 mysql 配置文件之前加的 “skip-grant-tables” 删除掉再重启就OK了