top of page

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

If you are facing such an issue in your MySQL environment for Password policy you need to reset your password validate the policy.

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. Password Validate exposes system variables that enable you to configure password policy and status variables for component monitoring.

First, you log in with MySQL as a super user and check the current policy rules.

[root@DBATrainings ~]# mysql -u root -p"your password"


Let us see various methods to resolve this issue.

Method 1: Let us see how we can set the password_policy to low:

SET GLOBAL validate_password_policy=LOW;

Method 2: You can also set the same variable in my.cnf file as well.



Method 3: Uninstall Plugin which validates the password

uninstall plugin validate_password;

Let's guide you the step by step solution for the same.

As I said earlier, I strongly prefer that you keep your password complex and protect yourself from malicious attacks.

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

mysql> SHOW VARIABLES LIKE 'validate_password%';

mysql> SET GLOBAL validate_password_policy=LOW;

You can choose the complexity as per your project policy. In short MySQL password policy to Low = 0 / Medium = 1 / High = 2. you can choose as Test, Development & Prod environment.

SET GLOBAL validate_password_policy=0;

SET GLOBAL validate_password_policy=1;

SET GLOBAL validate_password_policy=2;

If you found it helps you or someone please like and share with others as well.

83 views0 comments

Recent Posts

See All

How to Connect MySQL Without Root Password.

Many times, I got the question from my colleague or training participants, how to login MySQL if I forgot the password. I have explained the process in many times to them but thought to write this sce

Step by Step Oracle 21c Installation on Linux

Oracle Database 21c is the first Oracle database release with CDB-only architecture. Oracle 20c was announced only CDB architecture but it was not release for on premises. Only for Cloud. That's why i


bottom of page