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