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!

Set skip-name-resolve=1 in my.cnf

Discussion in 'Database Discussion' started by Jesse Distad, Mar 23, 2019.

  1. Jesse Distad

    Jesse Distad Member

    Joined:
    Mar 23, 2019
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    MN, USA
    cPanel Access Level:
    Root Administrator
    I'm in the process of optimizing mysql on a new server and one of the recommendations is to set skip-name-resolve=1

    I have read in multiple places that doing so has caused issues on cPanel servers but those reports are not all that current, I'd like a definitive answer if this can be done without issue. I currently have bind_address set to 127.0.0.1

    Will setting skip-name-resolve=1 affect accounts that have localhost set for their database connection?

    thanks in advance
     
    #1 Jesse Distad, Mar 23, 2019
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,478
    Likes Received:
    185
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    It does not break localhost connections.

    I have seen errors in the backup logs with this on though but I do not believe it's actually affecting backups. But to be Frank I have not experimented much on it.

    Cpanel official might have more info.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 GOT, Mar 23, 2019
  3. Jesse Distad

    Jesse Distad Member

    Joined:
    Mar 23, 2019
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    MN, USA
    cPanel Access Level:
    Root Administrator
    Thanks for the feedback.. Maybe there will be someone by to reply now that the weekend is over, eventually, hopefully :D
     
    #3 Jesse Distad, Mar 24, 2019
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,241
    Likes Received:
    478
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Skip name resolve can cause issues on cPanel servers and the benefit isn't necessarily notable. The backup errors I've not seen but we do recommend adding this to the MySQL configuration at your own discretion, it's not recommended.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelLauren, Mar 26, 2019
(You must log in or sign up to post here.)
Loading...
Similar Threads - skip name resolve=1
  1. LaLi

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    LaLi, Jul 28, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    1,170
    cPanelLauren
    Mar 25, 2019
  2. Rodolfo Berrios

    API tokens being skipped?

    Rodolfo Berrios, Jun 8, 2019, in forum: cPanel Developers
    Replies:
    1
    Views:
    103
    cPanelMichael
    Jun 10, 2019
  3. WebHostPro

    SOLVED Warning: Skipping the following R/0 filesystems: /sys/fs/cgroup

    WebHostPro, May 13, 2019, in forum: General Discussion
    Replies:
    3
    Views:
    368
    cPanelMichael
    May 16, 2019
  4. Michael A.

    Pruning of backup files skipped due to errors

    Michael A., Jan 2, 2019, in forum: Data Protection
    Replies:
    7
    Views:
    476
    cPanelLauren
    Jan 15, 2019
  5. SamL

    SOLVED [CPANEL-22560] AutoSSL Warning - Skipping duplicate domains (misconfigured?)

    SamL, Oct 18, 2018, in forum: Security
    Replies:
    1
    Views:
    313
    cPanelFelipe
    Oct 19, 2018

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.
    Accept Learn More...
    Dismiss Notice