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!

Does cpanel allow custom user my.cnf

Discussion in 'Database Discussion' started by Aquanuke, Jun 17, 2011.

  1. Aquanuke

    Aquanuke Member

    Joined:
    Dec 11, 2002
    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    153
    Hi im on a shared server and have no root access. I need to tweak mysql to add query cache, can I create a my.cnf at /home/user/.my.cnf

    I have tried it but am unable to restart mysql to make changes take effect to see if it worked.
     
  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
    You cannot have a user-defined customized my.cnf at the account level. MySQL will not support this option. The only user defined option is the password for your user which can be set using a .my.cnf at the account level. Any other options will be ignored.

    I suggest asking your host to add this setting, or alternatively obtaining a VPS where you could control your own node and then have your own my.cnf settings.
     
    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