Skip to main content

Posts

Showing posts from March, 2018

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

This error usually pops up when you try to grant permissions on your database in MySQL. In this case, you have two options. Option 1:  Change your password so that it satisfies the current policy requirements in your MySQL installation. You can check what conditions are required by executing the bellow command on the terminal where MySQL is running. SHOW VARIABLES LIKE 'validate_password%';   It will list down a table like this,   Option 2 : Set the password policy level lower. For example, you can change the allowed password length using the below command. You also can do this for the fields shown in the image above. SET GLOBAL validate_password_length = 6 ;  Cheers!