How to Start/Stop MySQL Server in CentOS 6

The service and chkconfig script are used to verify all the services whether it is running or stopped and enable or disabled at startup.
Run the following commands to check service status startup status:

[root@linuxcnf ~]# service mysqld status mysqld (pid  27892) is running... [root@linuxcnf ~]#  [root@linuxcnf ~]# chkconfig --list mysqld mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off [root@linuxcnf ~]#

  

Run the following commands to start the MySQL service and configure it to automatically start when Linux server is booted by default:

[root@linuxcnf ~]# service mysqld start Starting mysqld:                                           [  OK  ] [root@linuxcnf ~]# [root@linuxcnf ~]# chkconfig mysqld on [root@linuxcnf ~]#

Run the following commands to stop the MySQL service and configure it to stop when Linux server is rebooted and do not start by default:

[root@linuxcnf ~]# service mysqld stop Stopping mysqld:                                           [  OK  ] [root@linuxcnf ~]# [root@linuxcnf ~]# chkconfig mysqld off [root@linuxcnf ~]# [root@linuxcnf ~]# chkconfig --list mysqld mysqld          0:off   1:off   2:off   3:off   4:off   5:off   6:off [root@linuxcnf ~]#

Now the MySQL Service is stopped and will not start when the server will reboot.