ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

在mysql 5.7 中,进入mysql执行操作时 ,出现以下提示

mysql> select version();
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

执行以下命令进行更改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Hi$12345';
Query OK, 0 rows affected (0.00 sec)

出现ERROR 1819 (HY000): Your password does not satisfy the current policy requirements错误 请转至 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

2017-3-27 11:20:13

点赞