When changing a cPanel user's password via WHM > List Accounts or WHM > Modify an Account, you may receive a MySQL error that includes the following entry:
Can't find any matching row in the user table
This issue occurs when skip-name-resolve is enabled within MySQL. We recommend having this setting disabled on cPanel servers. We have this documented in the Transfer Tool 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.
To work around this, you will need to comment out or remove the entry for skip-name-resolve within /etc/my.cnf and then restart MySQL. You can restart MySQL with the following cPanel script: