Friday, June 23, 2017

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

If you are getting below error with mysql 5.7.18 while updating password & can't restart your mysql-server
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Solution -

Check validate password values with below command 

SHOW VARIABLES LIKE 'validate_password%';

Just set your Validate Password policy to LOW with below command


SET GLOBAL validate_password_policy=LOW; 

Now you can update the password. By default the value is MEDIUM & you can set the same to default once your work is complete


 If you want it permanently, You can simply disable the same with below setting in /etc/my.cnf
validate-password = off

Note- You need to restart mysql server to reflect any changes with my.cnf file

No comments:

Post a Comment