In this article we are going to see solution for following error. Which occurs in MySQL when tried to create a user or change the password of MySQL user.
MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements.
Reason for MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
Reason is simple, password policy level set to medium or strong.
Solution:
We have to give strong password or set the validate_password.policy to medium.
Step to resolve this error:
1. Verify the password policy of MySQL server settings by running below query.
SHOW VARIABLES LIKE 'validate_password%';
Observation from the above result is, validate_password.policy is set to MEDIUM.
2. We are going to modify it to LOW by running following mysql statement. To do this, we should root user privileges.
SET GLOBAL validate_password.policy=LOW;
3. Now, verify password policy changed or not by running below command.
SHOW VARIABLES LIKE 'validate_password%';
Another solution as discussed above is, we have to provide strong password which must contains length more than characters and mix of strings,number and special characters.
4. Now, try to create user or modify the password of MySQL user. The above error will not occurs.