MySQL Red hat linux

Password Validation Plugin in MySQL

The validate_password plugin serves to test passwords and improve security. The plugin exposes a set of system variables that enable you to define password policy.

First check the plugin directory of MySQL.

Go to given path and check it. We can see lots of plugins are present in Plugin Directory Of MySQL. We need PASSWORD_VALIDATE.SO file.

Now Stop MySQL Services

Now open my.cnf file of MySQL at /etc/ and add below lines.

Start MySQL Services

Now login to MySQL And execute below command.

Now as you can see above. you can define policy as per your requirement like what should be password length and how many character and special character should be present in the password.

Now try to assign some simple password and check if it accepts. We can see its not accepting simple password.

Leave a Reply

Your email address will not be published. Required fields are marked *