Error Assigning MySQL User to Database

Symptoms

When adding a MySQL user to a database within cPanel, you receive an error with the following description:

User "cpuser_dbuser" could not be added to the database "cpuser_database". The request failed. (Error ID: v2d9ph) Ask your hosting provider to research this error in cPanel & WHM's main error log.

When you search for the error ID in cPanel's error log, you will find the following error:

[20XX-01-01 00:00:00 -0700] warn [cpwrapd] The system could not perform “GRANT” statements on the database “cpuser_dbuser” for the user “cpuser” due to errors: Cpanel::Exception::Database::Error/(XID v2d9ph) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

Description

MySQL will encounter an error during many operations if the "skip-name-resolve" option is enabled in the configuration. Disabling the option should correct the error.

Workaround

1. Access your server using SSH as the root user
2. For safety, make a backup of the MySQL configuration file:

   cp /etc/my.cnf{,.$( date +%Y%m%d )} -v

3. Using your preferred text editor, open and edit the configuration file:

   /etc/my.cnf

4. Find and remove the following line from the file:

   skip-name-resolve

5. Save the file and restart MySQL to commit the changes:

   /scripts/restartsrv_mysql

Additional Resources

Should I use skip-name-resolve in my.cnf?