代码改变世界

mysql8.0.11-1 修改密码报错

2018-05-14 15:26  方斌  阅读(2551)  评论(0)  编辑  收藏  举报

报错信息

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements


原因

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#sysvar_validate_password.policy

image

处理措施

mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password.length=8;
Query OK, 0 rows affected (0.00 sec)