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!

MySQL does not start on boot

Discussion in 'General Discussion' started by iLinux85, Mar 20, 2013.

  1. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    41
    Likes Received:
    2
    Trophy Points:
    58
    hello

    when i restart the server , all services running well , except mysql not start , i should start it manually , so how could mysql start by it self like httpd

    thanks
     
  2. cPanelJared

    cPanelJared Technical Analyst

    Joined:
    Feb 25, 2010
    Messages:
    1,835
    Likes Received:
    20
    Trophy Points:
    143
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    What is the output of this command?

    Code:
    # chkconfig --list mysql
    mysql          	0:off	1:off	2:on	3:on	4:on	5:on	6:off
    If it does not say "on" for levels 3 and 5, run this command:

    Code:
    # chkconfig --level 35 mysql on
    That will make the MySQL service start on boot.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    41
    Likes Received:
    2
    Trophy Points:
    58
    Code:
    root@sawa4 [/]# chkconfig --list mysql
    service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')
    Code:
    root@sawa4 [/]# chkconfig --level 35 mysql on
    root@sawa4 [/]#
    Code:
    root@sawa4 [/]# chkconfig --list mysql
    mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off
    this should be automaticly running now ?
     
  4. CitizenK

    CitizenK Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    64
    Likes Received:
    1
    Trophy Points:
    58
    Location:
    On The Road
    cPanel Access Level:
    Root Administrator
    That is correct. MySQL should now start on boot. Additionally if the mysql server is down you can start it without rebooting with this command.
    Code:
    /scripts/restartsrv_mysql
     
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