Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Grant existing database user access to a specific database?

Discussion in 'Database Discussion' started by linux1212, Feb 19, 2018.

  1. linux1212

    linux1212 Registered

    Joined:
    Jan 17, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,855
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Clixer

    Clixer Active Member

    Joined:
    Feb 24, 2018
    Messages:
    30
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    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.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,855
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice