How-To Resolve "ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)" when installing WordPress via WP Manager

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

1. Open /etc/my.cnf in your preferred text editor
   How to edit a file on command-line
2. Comment or delete the line that contains skip-name-resolve

   #skip-name-resolve=On

3. Restart MySQL
   

   /scripts/restartsrv_mysql