CentOS7在线安装MySQL5.7及设置

1. 安装MySQL5.7

sudo yum install -y -q https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
sudo yum -y install yum-utils
sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community
sudo yum install -y mysql-community-server

2. 启动服务

sudo systemctl enable mysqld
sudo systemctl start mysqld

3. 查询初始密码

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

4. 使用初始密码登录

mysql -uroot -p
Enter password:  #输入初始密码

5. 更改密码复杂度策略，可以设置简单密码

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

6. 修改默认密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; 

7. 允许root访问

mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
mysql> flush privileges;