The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH

The system could not perform “GRANT” statements for the user “username” due to errors: (XID cw2xap) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table), (XID yhghf3) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row in the user table) at /usr/local/cpanel/Cpanel/DBAdmin.pm

I was upgrading a customer today from SQL 5.5 to MariaDB 10 and when he was trying to add users to a db from cPanel it wasn’t working.

cPanel error logs showed the thing above and apparently this is triggered by having “skip-name-resolve” enabled in my.cnf. Disable it, and run /scripts/restartsrv_mysql

Voila!

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge