- 安装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
- 启动服务
sudo systemctl enable mysqld
sudo systemctl start mysqld
- 查询初始密码
grep 'temporary password' /var/log/mysqld.log
- 使用初始密码登录
mysql -uroot -p
Enter password: #输入初始密码
- 更改密码复杂度策略,可以设置简单密码
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
- 修改默认密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
- 允许root访问
mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
mysql> flush privileges;