Skip to main content

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

Zachary Karr
  • Updated

Symptoms

When attempting to create a new MySQL database user in cPanel, the interface can show:

CONFIG_TEXT: The request failed. (Error ID: f7kx27) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

You may also experience a similar error when accessing phpMyAdmin.

When checking the cPanel error_log, a message similar to the following is found:

CONFIG_TEXT: 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)

 

Cause

This issue can be caused by having the "validate_password" MySQL plugin enabled.

 

Resolution

To remove the "validate_password" plugin:

MySQL 8.0 or greater
  1. Log in to the server via SSH or WHM's Terminal as the root user

  2. Verify if the plugin is enabled by running the following command:

    # mysql -sse "SELECT * FROM mysql.component"
    2 1 file://component_validate_password

  3. If the plugin is enabled, you can remove it by running the following command:

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

MySQL 5.7 or lower
  1. Log in to the server via SSH or WHM's Terminal as the root user

  2. Verify if the plugin is enabled by running the following command:

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

  3. If the plugin is enabled, you can remove it by running the following command:

    # mysql -e "uninstall plugin validate_password;"

Related articles

Comments

0 comments

Article is closed for comments.

%