User could not be added to the database error

[maestroc]

Recently I have ran into the problem on all of the accounts on my server when using WHM's MySQL Database Wizard to create a new database and user. The database and the user are created (I can see them in the list if I go back to the MySQL Databases screen), but in the final step of the wizard when it is time to assign permissions to that new user I get an error every time and on every account. The error message is

User “xyz_pdq” could not be added to the database “xyz_pdq". (XID hu6cmw) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

I found this posting on another forum that suggests a fix:

linuxadminonline.com/issue-system-received-error-mysql-database-mysql-er_password_no_match-cant-find-matching-row-user-table/

He says to comment out the skip-name-resolve variable in my.cnf

but I don't want to turn that off in case it is important somehow. Any idea what I should do to fix this problem? As I said it happens server wide, even on newly created accounts.

 

[cPanelMichael]

He says to comment out the skip-name-resolve variable in my.cnf

but I don't want to turn that off in case it is important somehow. Any idea what I should do to fix this problem? As I said it happens server wide, even on newly created accounts.

Hello,

The use of this entry is unsupported. Could you remove the entry, and then restart MySQL, to verify it solves the issue?

Thank you.