"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 » List Accounts or WHM » Modify an Account, you receive a MySQL error that includes the following entry:

Can't find any matching row in the user table

Description

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:

• 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.

Workaround

Comment out or remove the entry for skip-name-resolve in /etc/my.cnf and restart MySQL with the following command:

/scripts/restartsrv_mysql