How Do I Restart MySQL Server?http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/
'"
n".self::process_list_items("'.str_replace('
', '', '
- E-mail this to a friend (http://theos.in/tools/emailpost.php?continue=264&hash=2&url=http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/&subject=How%20Do%20I%20Restart%20MySQL%20Server?)
- Last updated: Dec/12/2008 (http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/#)
').'")."n[/list]"'
37 comments (http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/#comments)
Each distribution comes with a shell script (read as service) to restart / stop / start MySQL server. First login as root user and open shell prompt (command prompt).
First login as root user. Now type the following command as per your Linux distro:
A) If you are using mysql on RedHat Linux (Fedora Core/Cent OS) then use following command:* To start mysql server:
/etc/init.d/mysqld start[/code]* To stop mysql server:
/etc/init.d/mysqld stop[/code]* To restart mysql server
/etc/init.d/mysqld restart[/code]Tip: Redhat Linux also supports service command, which can be use to start, restart, stop any service:
# service mysqld start # service mysqld stop # service mysqld restart[/code]
(B) If you are using mysql on Debian / Ubuntu Linux then use following command:* To start mysql server:
/etc/init.d/mysql start[/code]* To stop mysql server:
/etc/init.d/mysql stop[/code]* To restart mysql server
/etc/init.d/mysql restart[/code]