Symptoms
Seeing an error such as
Error/(XID fd46n5) The system received an error from the "MySQL" database "mysql":
1819 (Your password does not satisfy the current policy requirements)
Description
If you get a message like this when attempting to create a MySQL User, you likely have an additional plugin installed. We have the following article for the validate_password plugin.
But there is another plugin that can be installed in MariaDB called Cracklib Password Check Plugin that is incompatible with the cPanel & WHM software. It will prevent the addition of MySQL users using either the WHM and cPanel user interfaces and also the API calls.
You can check to see if this is the case with the following command
MariaDB [(none)]> SHOW VARIABLES LIKE '%pass%';
+------------------------------------+-----------------------------+
| Variable_name | Value |
+------------------------------------+-----------------------------+
| cracklib_password_check_dictionary | /usr/share/cracklib/pw_dict |
| old_passwords | OFF |
| report_password | |
| strict_password_validation | ON |
+------------------------------------+-----------------------------+
4 rows in set (0.001 sec)
If you see cracklib_password_check_dictionary, then this is the problematic plugin causing your issues.
Workaround
Uninstall the plugin or simply disable it.
MariaDB [(none)]> UNINSTALL PLUGIN cracklib_password_check;