Recently i could not add MySQL user to MySQL Database in cPanel. There was no error message displayed on screen. The operation just failed.
Then i tried to use cPanel MySQL Database Wizard to create a new database, new user, and add that new user to the new database. Then i saw the error message in my browser.
User “xxx” could not be added to the database “yyy”. The request failed. (Error ID: zzz) Ask your hosting provider to research this error in cPanel & WHM’s main error log.
It must be caused by recent cPanel / MySQL updates, because everything worked fine few weeks before.
Then i checked the cPanel error log
cd /usr/local/cpanel/logs/ tail -100 error_log
There, i noticed this error :
[2023-01-01 00:00:00 -0000] warn [cpmysql] Error from MySQL query: Cpanel::Exception::Database::Error/(XID xxx) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can’t find any matching row inthe user table) at /usr/local/cpanel/Cpanel/DBI.pm line 200, line 1.
From google, i got this article.
So i tried to disable
skip-name-resolve from MySQL configuration file which is located in
And i restarted MySQL.
Then everything works fine again.