Grant existing database user access to a specific database?

linux1212

Registered
Jan 17, 2018
1
0
1
San Antonio, Texas
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
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:

Code:
grep skip-name-resolve /etc/my.cnf
This option is unsupported, and can lead to the error message you have provided.

Thank you.
 

Clixer

Active Member
Feb 24, 2018
41
2
8
Australia
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
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.