When configuring MYSQL server or MYSQLd, sometimes you need to stop then need to restart the MYSQL server. In Linux environment you can use several command to start and stop the MySQL server, below is some example of the command that is executed and tested on fedora operating system.

Using service command to start or stop MySQL server:

1. To stop Mysqld:

[root@fedora ~]# service mysqld stop

Stopping MySQL:                                     [ OK ]

-- Execute the same command again to verify that your MySQLd stop --

[root@fedora ~]# service mysqld stop

Stopping MySQL:                                     [FAILED]

[root@fedora ~]#

or

[root@tenouk ~]# /etc/init.d/mysqld stop

Stopping MySQL:                                     [ OK ]

[root@fedora ~]#

2. To start MySQL / MySQLd:

[root@fedora ~]# service mysqld start

Starting MySQL:                                     [ OK ]

[root@fedora ~]#

or

[root@tenouk ~]# /etc/init.d/mysqld start

Starting MySQL:                                     [ OK ]

[root@fedora ~]#

To auto start the MySQL after your operating system reboot:

1. The Linux command that can be use to check the list of service that start on certain run level:

[root@tenouk ~]# chkconfig --list

2. To check only MySQLd server:

[root@fedora ~]# chkconfig --list mysqld

mysqld       0:off       1:off       2:off       3:off       4:off       5:off       6:off

[root@fedora ~]#

3. To make MySQLd auto start when you boot your computer:

[root@fedora ~]# chkconfig --level 35 mysqld on

Note:   Run Level 3 = Full multiuser mode with no GUI

                  Run Level 5 = X11 or GUI mode

4. Use the chkconfig again to verify the changes:

[root@fedora ~]# chkconfig --list mysqld

mysqld       0:off       1:off       2:off       3:on       4:off       5:on      6:off

[root@fedora ~]#

To Configure which services will be running when the system starts using GUI:

1. Go to Luncher panel click on System -> Administration -> Server Settings and click on -> Services

2. Or you can type in on the x terminal as example below:

[root@fedora ~]# /usr/bin/system-config-services &

[1] 14063

[root@fedora ~]# NetworkManager

This will open Service Configuration window:

NOTE: use su -c command to execute command above if you not log in as root user