When attempting to create a new MySQL database user in cPanel, the interface can show:
The request failed. (Error ID: f7kx27) Ask your hosting provider to research this error in cPanel & WHM’s main error log.
When checking the cPanel error_log, a message similar to the following is found:
info [cpwrapd] ERROR in Mysql query :(XID vwqrz2) The system received an error from the “MySQL” database “mysql”: 1819 (Your password does not satisfy the current policy requirements)
This issue can be caused by having the "validate_password" MySQL plugin enabled. This can be checked with the following:
# mysql -sse "SELECT name FROM mysql.plugin"
To uninstall the plugin, run the following:
# mysql -e "uninstall plugin validate_password;"