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
| 1 2 3 4 | mysql> SET PASSWORD = PASSWORD(‘test’); ERROR 1819 (HY000): Your password does not satisfy the current policy requirements |
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
| 1 2 3 | uninstall plugin validate_password; |
If you want to enable it again, Run the command
| 1 2 3 | INSTALL PLUGIN validate_password SONAME ‘validate_password.so’; |
To Check if the plugin is enabled
| 1 2 3 4 5 6 7 8 9 | mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS -> WHERE PLUGIN_NAME LIKE ‘validate%’; +—————————–+———————–+ | PLUGIN_NAME | PLUGIN_STATUS | +—————————–+———————–+ | validate_password | ACTIVE | +—————————–+———————–+ |
See the screenshot below
