MySQL – ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

If you run into this error it's a strong indicator that the Password Validation Plugin is installed.

Disabling Password Validation Plugin

The quick and dirty way to fix this is to uninstall the plugin. You will need to be the root user in the database.

# mysql -u root -p

Type your password, then uninstall the plugin:

mysql> uninstall plugin validate_password;

Verify Status of Password Validation

If you really want to dig in deeper you can play with the plugin configuration. You do that by logging into MySQL and running the following:

NOC - MySQL Validate Password

This will show you the Plugin table and the associated settings. You can manipulate any of the settings in the table by doing any of the following:

mysql> SET GLOBAL validate_password_length = 6;
mysql> SET GLOBAL validate_password_number_count = 0;
mysql> SET GLOBAL validate_password.policy = LOW;

Be forewarned that I tried resetting some of the values and had little luck until I removed the plugin. In reality, I didn't need the plugin. I use a random password generator for all my passwords.

To learn more about the Password Plugin Categories see this page:

Posted in   Troubleshooting   MySQL     by noc_team

Improve Your Websites Speed and Security