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!

skip-name-resolve for MySQL

Discussion in 'Database Discussion' started by Ricky Castillo, May 7, 2016.

  1. Ricky Castillo

    Ricky Castillo Registered

    Joined:
    May 7, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Panama
    cPanel Access Level:
    Root Administrator
    I kept getting the error DBD::mysql::db do failed: Can't find any matching row in the user table. The error seems to go away when skip-name-resolve is commented on /etc/my.cnf

    I also read an old threat (pkgacct - "no such grant defined for user" - Cpanel/Mysql.pm line 515) that clearly states as cPanel needing skip-name-resolve not enabled.

    We are running on WHM 56.0 (build 14), hope this helps anyone with the issue as well.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,952
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    cPanel isn't designed or tested with the skip-name-resolve option in the /etc/my.cnf , so enabling this option in your /etc/my.cnf file will break certain functionality. Is there a specific reason you have enabled it on this system? The easier path to addressing the issue is to resolve the problem that's leading to the use of the option.

    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