MySQL "Your password does not satisfy the current policy requirements"

Symptoms

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)

Description 

This issue can be caused by having the "validate_password" MySQL plugin enabled. This can be checked with the following:

For MySQL 5.7 or lower:

# mysql -sse "SELECT name FROM mysql.plugin"
validate_password

For MySQL 8.0 or greater:

# mysql -sse "SELECT * FROM mysql.component"

If the above does not show, it is possible that the Cracklib Password Check is enabled.

Workaround

To uninstall the plugin, run the following:

For MySQL 5.7 or lower:

# mysql -e "uninstall plugin validate_password;"

For MySQL 8.0 or greater:

# mysql -sse "UNINSTALL COMPONENT 'file://component_validate_password';"