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!

/etc/my.cnf has no effect?

Discussion in 'General Discussion' started by Gavster, Aug 2, 2005.

  1. Gavster

    Gavster Active Member

    Joined:
    Apr 3, 2002
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    301
    Howdy all,

    I'm not finding an answer to this on a search of the forum here, so I'm opening a new thread - feel free to point me in the right direction if there is actually a post somewhere in here about this.

    I've added the following to /etc/my.cnf [mysqld] section:

    set-variable=wait_timeout=300

    Saved and restarted mysql, and then logged into mysql on the command line, where a SHOW VARIABLES tells me that wait_timeout is 28800 (the default value). I also tried it without the "set-variable" part in /etc/my.cnf to no effect.

    So it seems as if editing /etc/my.cnf is having no effect on the server settings. Am I missing something here?

    On non-cPanel servers that we have, editing /etc/my.cnf is all that is required to change a variable, but on our cPanel boxes, nothing happens.

    Has anyone seen this before?


    Kind regards,

    Gavin
     
  2. carteluo

    carteluo Member

    Joined:
    Jun 25, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Porlamar
    cPanel Access Level:
    Root Administrator
    Twitter:
    If you have installed MySQL 4.X note that set-variable is deprecated, just use variable=value on its own. In yor case:

    wait_timeout=300

    Cheers
     
  3. Gavster

    Gavster Active Member

    Joined:
    Apr 3, 2002
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    301
    Hi Carteluo -

    As stated in my initial post:

    'I also tried it without the "set-variable" part in /etc/my.cnf to no effect.'

    Kind regards,

    Gavin
     
  4. carteluo

    carteluo Member

    Joined:
    Jun 25, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Porlamar
    cPanel Access Level:
    Root Administrator
    Twitter:
    Can you paste your complete /etc/my.cnf file here so we can take a look?
     
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