Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How would I configure my CentOS Linux server to automatically start mysql when the server is started following a shutdown?

I'm aware of the init.d path...

/etc/rc.d/init.d

...and I can see mysqld in this folder. I believe that placing items (i.e. by symbolic link) in this folder means that they should start on server restart.

But this did not happen for me.

Background

Our central IT desk restarted our virtualised CentOS servers over the weekend. The server was available following restart but the MySQL database had not restarted also.

Thoughts?

share|improve this question

1 Answer 1

up vote 5 down vote accepted

Use chkconfig:

chkconfig --level 345 mysqld on
share|improve this answer
    
+1 Thanks BUT should this be chkconfig --level 345 mysqld on NOT chkconfig --levels 345 mysqld on ? linuxcommand.org/man_pages/chkconfig8.html I tried both. I'm guessing it worked by there was no message or anything, after typing it, I just got another prompt. Any way to tell if it makes mysql restart automatically? –  therobyouknow Feb 7 '11 at 9:06
    
@Rob: run chkconfig --list mysqld to show what runlevels that init script is set for. –  Scott Pack Feb 7 '11 at 13:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.