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

Symptoms

When attempting certain database administration tasks through the cPanel interface(such as creating users), the task fails, and you find the following in the cPanel error logs:

Cpanel::Exception::Database::Error/(XID m369yu) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.

Description

This will occur if the "skip-name-resolve" option has been enabled in the server's MySQL configuration file. This option prevents cPanel from making required changes to the "mysql.user" table. It should be disabled to allow cPanel to properly manage your databases and users.

Workaround

Remove the "skip-name-resolve" option from the configuration file:

1. Connect to your server through SSH as the root user
2. Create a backup of your MySQL configuration before making changes:

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

3. Using your preferred text editor, open the MySQL configuration file here:

   /etc/my.cnf

4. Locate the following entry in the file and either remove it or comment it out:

   skip-name-resolve

5. Save the file and restart the MySQL service:

   /scripts/restartsrv_mysql