Symptoms
Adding a database user to a database results in the following error, or similar:
The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
Cause
The MySQL option "skip-name-resolve" is enabled.
Resolution
Remove the "skip-name-resolve" option from the configuration file:
- Connect to your server through SSH as the "root" user
-
Create a backup of your MySQL configuration before making changes:
-
cp -v /etc/my.cnf{,.$( date +%Y%m%d )} -v
- Using your preferred text editor, open the MySQL configuration file at
/etc/my.cnf. -
Locate the following entry in the file and either remove it or comment it out:
skip-name-resolve
-
Save the file and restart the MySQL service:
-
/scripts/restartsrv_mysql
