The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

skip-name-resolve for MySQL

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

  1. Ricky Castillo

    Ricky Castillo Registered

    Joined:
    May 7, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,814
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page