How to automatically restart MySQL after server rebooted?

chanjay · 05-01-2012, 01:02 PM

Hi,

I have a web site that uses MySQL database. My problem is whenever the web server got rebooted, I have to manually restart the MySQL server (/etc/init.d/mysqld restart) otherwise the web site does not work.

Is there a way to do automatic restart to the MySQL after the web server has rebooted?

Thanks.

hc.

suicidaleggroll · 05-01-2012, 01:03 PM

You could put the "/etc/init.d/mysqld restart" call in the startup script. Where the startup script is located depends on your distro.

Satyaveer Arya · 05-01-2012, 06:01 PM

Just use chkconfig mysqld on only one time. And whenever the server gets reboot, it will automatically restart the mysqld service.
You can also check the man page of chkconfig command to run the service on particular runlevels only according to your need.
By default it will start on runlevel 2, 3, 4 & 5.

whysoserious · 05-01-2012, 07:33 PM

Install webmin. There is an option to set the mysql server to start at boottime when you click on the servers module on the left. Also it enables a lot of other tasks to be done quickly! Hope that helped.

whysoserious · 05-01-2012, 07:37 PM

Quote:

Originally Posted by suicidaleggroll

You could put the "/etc/init.d/mysqld restart" call in the startup script. Where the startup script is located depends on your distro.

Would it not be dependant on the distro sir. I think it would be start instead of restart or does that not make a difference.

suicidaleggroll · 05-02-2012, 11:01 AM

Quote:

Originally Posted by whysoserious

Would it not be dependant on the distro sir. I think it would be start instead of restart or does that not make a difference.

The location of the startup script would depend on the distro. The command for starting/restarting the mysql service I just grabbed from his original post. For an initial start, yes "start" would be more correct, but "restart" should still do the job.