How to automatically start mysql after server restart (CentOS + other distros)?

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?

Solution 1:

Use chkconfig:

chkconfig --level 345 mysqld on

Solution 2:

To enable mysql service on startup, use following command.

systemctl enable mysqld.service

It will create appropriate symbolic link for you.