安装好mysql后我们会打印出一个初始的临时密码
grep 'temporary password' /var/log/mysqld.log
此时使用临时密码登录root账号
mysql -uroot -p
此时修改root密码时报错
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'hzero';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
错误异常信息:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
解决方法:原因是我们的密码过于简单不符合策略要求,可以先将密码设置为复杂密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Zmf315717/';
查看密码策略
将密码长度修改成你需要的位数,策略修改为低,就能将密码修改为简单的12345之类的了
set global validate_password_length=5;
set global validate_password_policy=LOW;
此时再重新设置为简单密码即可