1、 启动MySQL服务
- systemctl start mysqld
-
2、 查看MySQL服务是否启动成功
- systemctl status mysqld
-
3、 查看MySQL数据库初始密码
- grep "password" /var/log/mysqld.log
-
4、 使用刚刚获得的初始密码登录MySQL数据库
- mysql -u root -p
-
5、 先更改一个较为复杂的密码
- ALTER USER 'root'@'localhost' IDENTIFIED BY 'MySQL1!';
-
1、查看当前密码策略等级
- SHOW VARIABLES LIKE 'validate_password%';
-
2、降低安全策略等级:
- set global validate_password.policy=0;
-
3、降低密码长度需求:
- set global validate_password.length=4;
-
4、更改以后效果:
- SHOW VARIABLES LIKE 'validate_password%';
-
1、创建用户并且赋予权限
- create user 'root'@'%' identified by '123456';
- grant all on *.* to 'root'@'%';
- flush privileges;
-
MySQL5.7中密码策略是:validate_password_policy
MySQL8.0中密码策略是:validate_password.policy