Skip to main content

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!


Comments

Popular posts from this blog

How to import the Public Certificate of one WSO2 product to the trust store of another?

To demonstrate this point, I will use the 2 products WSO2 API Manager 2.1.0 (referred as APIM from here onwards) and WSO2 Enterprise Integrator 6.1.1 (referred as EI from here onwards). When using EI as the Business Process Server during configuration of Workflows in APIM, one step to perform is to import the public certificate of EI to the truststore of APIM [1]. So now let's see how this can be done. Step 1: Go to <EI_HOME>/repository/resources/security/ folder and execute the following keytool command. This command is used to export the public certificate of EI as a certificate file called wso2carbon.cer. Since the default keystore in EI is wso2carbon.jks, we have specified it as the keystore and the default alias is wso2carbon. Provide wso2carbon as the keystore password when prompted as it is the default password. After executing the above command from within the security folder in EI, you will see that a file with the name of wso2carbon.cer is created...