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.

/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:
    1
    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:
    1
    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:
    1
    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:
    1
    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