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!

Locating my.cnf

Discussion in 'Database Discussion' started by KeB, Sep 1, 2011.

  1. KeB

    KeB Member

    Joined:
    Feb 22, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    51
    I am trying to edit my.cnf but i am not sure which file is in use.

    I am running cPanel 11.30.2 on CentOS.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    The default my.cnf file is typically in /etc/my.cnf location.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. KeB

    KeB Member

    Joined:
    Feb 22, 2010
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    51
    Thanks for that.

    Does that file "work" globally then.

    I have just run mysqltuner and want to make the recommend changes, do i add them to this file?
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Yes, you would add them to that file as the global MySQL configuration.
     
    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