ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
出现这个报错,那是还需要重置密码一次
- mysql> alter user 'root'@'localhost' identified by '111';
输入以上语句,会提示:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirement.
- mysql> alter user 'root'@'localhost' identified by '123456';
MySQL5.7 加强了安全保障,以上意思是密码不符合安全策略要求,我们输入一个8位或以上长度,复杂一点的密码,比如:
Query OK, 0 rows affected (0.00 sec)
做完以上操作就修改密码成功了,然后就不会再提示错误了。