cPanel Can Not Add MySQL User to Database

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 /etc/my.cnf
And i restarted MySQL.

Then everything works fine again.