Introduction
When installing WordPress via WP Manager, you may encounter the following error:
Error from MySQL query: Cpanel::Exception::Database::Error/(XID 4qqazq) 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/DBI.pm line 200........
This error is due to skip-name-resolve being enabled in MySQL. This configuration is not supported on cPanel servers and we recommend having it disabled.
When skip-name-resolve is enabled, it can cause the "Can't find any matching row in the user table" error to appear when performing several MySQL-related functions within cPanel. For reference:
"Can't find any matching row in the user table" when changing passwords via WHM
Skip-name-resolve breaks restores with MariaDB on version 88
Procedure
To resolve this, we recommend disabling skip-name-resolve. To do this, you will need to remove the skip-name-resolve entry from /etc/my.cnf and then restart MySQL:
/scripts/restartsrv_mysql