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.

MySQL problem after 11.36 update

Discussion in 'General Discussion' started by Toufick, Mar 12, 2013.

  1. Toufick

    Toufick Member

    Joined:
    Mar 12, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Last night, cpanel was autoupdated to 11.36

    Since, each time I restart my VPS, MySQL is not restarted and this message is displayed on my website

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

    So each time my VPS is rebooted, I have to use this command to start MySQL

    /scripts/restartsrv_mysql

    Ho to remedy to this ?

    Many thanks in advance
     
  2. blahnana

    blahnana Registered

    Joined:
    Mar 17, 2013
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider
    I'm getting the same behaviour with several cPanel installations (all were first installed around 4-6 months ago). All similar circumstances, up to date in the cPanel RELEASE strain. Rebooting them causes them to boot perfectly, but MySQL isn't running after init. 'service mysql start' works perfectly. I've noticed that mysql isn't listed in 'chkconfig --list', but I don't remember noticing whether MySQL was there previously.

    I checked the service list in WHM, MySQL is enabled but not monitored.
     
  3. Toufick

    Toufick Member

    Joined:
    Mar 12, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi

    Here is the solution

    Run this command
    # chkconfig --list mysql
    If you get this message
    service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')
    Run
    # chkconfig --add mysql
    Then
    # chkconfig --levels 345 mysql on


    Solution given by Mark from cpanel support
     
Loading...

Share This Page