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:
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.
- PHP-FPM Pool Setup: WordPress Requires FTP/SFTP User After Successful Configuration
- PHP-FPM: ERROR: [pool [name1]] unable to set listen address as it’s already used in another pool ‘[name2]’
- ERROR 1064 (42000) at line 1 – Passing MySQL Create User Arguments via SSH
- NET::ERR_CERT_COMMON_NAME_INVALID When Moving SSL Certs Between Servers
- Troubleshooting Random Connection Errors with a WAF/CDN