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"


mysql>


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.


[mysqld]

validate_password_policy=LOW


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.





63 views0 comments

Recent Posts

See All

How to set cursor movement in oracle SQL

While you are working on SQL*Plus and RMAN on Linux environment and you did some mistake and you want to edit your query it won’t work by default. There is way to configure it. The rlwrap (readline wr

How to resolve Backspace key issue in sqlplus.

Backspace key does not work in sqlplus. It's not a issue form Oracle. This is a terminal type issue. echo $TERM stty -a and see if you have done anything special with the backspace key. I hope it’s wo

ADDRESS :

701, Linden, Rosalie Complex Khadakpada, Kalyan (W) Mumbai, Maharashtra 421301)

CONTACT US :

LOCATION :

QUICK LINKS :

SUBSCRIBE HERE :

Don’t Miss a Lecture. Subscribe Today. 

+919322846017  &   +919867493019

EMAIL: 

telegram-512.png

© 2021 DBA Trainings. Proudly Managed By SPIROSOFT IT SOLUTIONS

  • Grey LinkedIn Icon
  • Grey YouTube Icon
  • Grey Twitter Icon
  • Grey Facebook Icon