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
- Open /etc/my.cnf in your preferred text editor
How to edit a file on command-line - Comment or delete the line that contains skip-name-resolve
#skip-name-resolve=On
- Restart MySQL
/scripts/restartsrv_mysql
Comments
0 comments
Article is closed for comments.