MySQL does not start on boot

[iLinux85]

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

 

[JaredR.]

What is the output of this command?

# 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:

# chkconfig --level 35 mysql on

That will make the MySQL service start on boot.

 

[iLinux85]

root@sawa4 [/]# chkconfig --list mysql
service mysql supports chkconfig, but is not referenced in any runlevel (run 'chkconfig --add mysql')

root@sawa4 [/]# chkconfig --level 35 mysql on
root@sawa4 [/]#

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 ?

 

[CitizenK]

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.

/scripts/restartsrv_mysql