Tag Archives: mysql8.0.111

[Solved] MYSQL8.0.11-1 password modification error: ERROR 1819 (HY000)

error message:

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

 

Reason:

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

How to Solve”

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)