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
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-resolvesetting 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.
Comment out or remove the entry for
/etc/my.cnf and restart MySQL with the following command: