Cannot add user to database: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

Symptoms

Users cannot be added to databases, and privileges cannot be added to database users. An error similar to the following can also be found in the cPanel error log.

CONFIG_TEXT: warn [cpmysql] The system could not perform “GRANT” statements for the user “cpuser” due to errors: Cpanel::Exception::Database::Error/(XID x7fyu9) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

Cause

The issue occurs when the skip-name-resolve option is enabled in the SQL service configuration. This option should be disabled, as it is not compatible with cPanel.

Resolution

1. Access the server's command line as the root user via SSH or Terminal in WHM.

2. Backup the SQL configuration file.

   # cp -av /etc/my.cnf{,.$(date +%s)}

3. Open the /etc/my.cnf file in your preferred text editor.

4. Comment out the skip-name-resolve line by adding a # at the beginning:

   CONFIG_TEXT: #skip-name-resolve=On

5. Save the changes and exit the text editor.

6. Restart the SQL service

   # /scripts/restartsrv_mysql