Grant existing database user access to a specific database?

[linux1212]

Attempting To:

Grant an existing database user access to a specific database



Problem/Error:

The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)



Description:

cPanel/WHM is adding new entries to the “mysql” table as follows:


mysql> select host, user from user where user = 'm2contra_txllc';

+----------------------------------+----------------+

| host | user |

+----------------------------------+----------------+

| IP | m2contra_txllc |

| localhost | m2contra_txllc |

| hostname| m2contra_txllc |

+----------------------------------+----------------+

3 rows in set (0.00 sec)


These entries should only contain “localhost” -- but there’s no way to remove the additional “remote access hosts” from the system.


Here’s the documentation for allowing access from external hosts:

Remote MySQL - Version 68 Documentation - cPanel Documentation


I can’t find where it’s getting the IP / hostname

 

[cPanelMichael]

The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

Hello,

Check to see if the skip-name-resolve option is enabled in your /etc/my.cnf file with the following command:

grep skip-name-resolve /etc/my.cnf

This option is unsupported, and can lead to the error message you have provided.

Thank you.

 

[Clixer]

Hello @cPanelMichael,

If "skip-name-resolve" is removed from my.cnf then would it not adversely affect the performance of the mysql server?

Is the error "The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)", a Cpanel specific and if yes, when could this be fixed?

Thanks for help.

 

[cPanelMichael]

If "skip-name-resolve" is removed from my.cnf then would it not adversely affect the performance of the mysql server?

Hello @Clixer,

I've not seen reports of disabling this option leading to significant performance penalties, but I suppose it's possible. Using this option is not supported with cPanel & WHM at this time, and can lead to the error message you reported. I encourage you to vote and add feedback to the following feature request if you'd like to see it supported with cPanel & WHM:

Allow skip-name-resolve in the MySQL configuration.

Thank you.