"Can't find any matching row in the user table" when changing passwords via WHM

Symptoms

When changing a cPanel user's password via WHM at Home / Account Information / List Accounts or Home / Account Functions / Modify an Account, you will receive the following MySQL error:

CONFIG_TEXT: Can't find any matching row in the user table

Cause

This issue occurs when the skip-name-resolve option is enabled in MySQL. We recommend disabling this setting on cPanel servers. This is documented in the Transfer Tool documentation here:

Transfer Tool | cPanel & WHM Documentation

• Do not use the skip-name-resolve setting in your server’s MySQL® configuration. This setting can cause problems on any server. It will create more problems on remote MySQL servers during account transfers.

Resolution

To correct this error, we will want to comment out or remove the entry for skip-name-resolve in /etc/my.cnf and restart MySQL. To do so, please follow these steps. 

1. Log in to the server via SSH as the root user or access the Terminal in WHM

2. Use your preferred text editor to open the file. Using nano as an example:

   # nano /etc/my.cnf

3. Find any lines containing skip-name-resolve and remove the line, or add a # to the start of the line to comment it out. 
4. Save the changes to the file.

5. Restart the MySQL or MariaDB service with the following command:

   # /scripts/restartsrv_mysql