Linux Start/stop/restart MySQL database method

1. View MySQL version
Method one: status;
Method Two: Select version ();

2. mysql start, stop, restart common commands
A, starting mode
1. Start with service:
[[Email protected]/]# Service mysqld Start (5.0 version is mysqld)
[[Email protected] etc]# service MySQL start (5.5.7 version is MySQL)

2. Start with mysqld script:
/etc/inint.d/mysqld start

3. Start with Safe_mysqld:
safe_mysqld&

B, stop
1. Start with service:
Service Mysqld Stop

2. Start with mysqld script:
/etc/inint.d/mysqld stop

3, mysqladmin shutdown

C, restart
1. Start with service:
Service mysqld Restart
Service MySQL restart (5.5.7 version command)

2. Start with mysqld script:
/etc/init.d/mysqld restart

Linux Start/stop/restart MySQL database method