How to disable Mysql Password Validation Plugin?

In this article we will explain how to disable mysql password validation plugin.

The mysql validate_password plugin (available as of MySQL 5.6.6) serves to test the provided passwords and improve security. This plugin checks the passwords against the current password policy and rejects it if it is weak. This affects following mysql statements

* CREATE USER
* GRANT
* SET_PASSWORD

One example to see how this plugin works

This failed because provided password doesn’t satisfy the default policy requirement of minimum 8 characters in the password.

How to Disable Mysql password validation (validate_password )  plugin?

To  remove Mysql password validation (validate_password )  plugin completely

Login to the mysql server as root and run the following command

If you want to enable it again, Run the command

To Check if the plugin is enabled

See the screenshot below

mysql-validate-password

Leave a Reply

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