Grant existing database user access to a specific database?

linux1212

• February 19, 2018 10:06

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

  • February 19, 2018 16:59

  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.

  0
• 

  Clixer

  • May 26, 2018 03:43

  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.

  0
• 

  cPanelMichael

  • May 29, 2018 15:10

  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.

  0

Please sign in to leave a comment.