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

龙魂 • 2017-03-27 • Linux, mysql, 数据库 • 7 阅读

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

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

1 2	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)

1 2	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

版权声明：
作者：龙魂
链接：https://blog.wlzs.cn/error-1820-hy000-reset-password-alter-user-statement-executing-statement/
来源：学海无涯
文章版权归作者所有，未经允许请勿转载。

THE END

二维码

海报

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

在mysql 5.7 中，进入mysql执行操作时，出现以下提示 Shell mysql> select version(); ERROR 1820 (HY000): You must reset your……

Centos 6.5 安装 mysql 5.7

下一篇>>

搜索内容