The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table)

One of my proactive management customers came up to me today with an issue he’s been having on one of his cPanel/WHM servers: he has been trying to add a user to a database he created and he received this error:

The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table)

Apparently commenting out skip-name-resolve in /etc/my.cnf fixed it.

then run a MySQL server restart with: /scripts/restartsrv_ mysql and you should be good to go.