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.

Does cpanel allow custom user my.cnf

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

  1. Aquanuke

    Aquanuke Member

    Joined:
    Dec 11, 2002
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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.
     
Loading...

Share This Page