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 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:
    34
    Likes Received:
    0
    Trophy Points:
    6
    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
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    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.
     
  3. iLinux85

    iLinux85 Active Member

    Joined:
    Mar 28, 2010
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    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:
    8
    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