1.输入:
set global validate_passwod.policy=0;
set global validate_password.length=1;
报错如下:
2.说明没有启动安全检查插件
启动方法如下:sudo vim /etc/my.cnf
3.修改配置
增加以下内容:
plugin-load-add=validate_password.so
validate-password=FORCE_PLUS_PERMANENT
4.重启mysql服务
systemctl restart mysqld.service
systemctl status mysqld.service
重启成功如下:
5.登录mysql
刷新权限:flush privileges;
6.查看安全策略:
SHOW VARIABLES LIKE 'validate_password%';
7.再次输入:
set global validate_password.policy=0;
set global validate_password.length=1;
8.设置自定义密码:
alter user 'root'@'localhost' identified by '123456';