Command mode start/stop/reboot MySQL server

First, the way to start

1, use service to start: Service mysqld start

2. Start with mysqld script:/etc/init.d/mysql start

3. Use Safe_mysqld to start:safe_mysqld&

Second, stop

1, use service to start: Service mysqld stop

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

3, mysqladmin shutdown

Third, restart

1, use service to start: Service mysqld restart

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

3. Enter the bin/directory under the MySQL installation directory:

Stop MySQL:./mysqladmin-u-P shutdown

Start MySQL: ./mysqld_safe&

Reboot, stop, boot in Linux server

For example, on Linux PPC, directories are/ETC/RC.D and/ETC/RC.D/RC3.D, so you can install scripts like this:

The code is as follows	Copy Code
#cp MYSQL.SERVER/ETC/RC.D/INIT.D #cd/ETC/INIT.D #chmod Mysql.server #cd/ETC/RC.D/RC3.D #ln-S. /init.d/mysql.server S99mysql

On Solaris, the main script directory is/ETC/INIT.D, and the Run level directory

It's/etc/rd2.d, so the order looks like this:

code is as follows	copy code
#cp MYSQL.SERVER/ETC/RC.D/INIT.D #cd/etc/init.d #chmod mysql.server #cd/etc/rc2.d #ln-S ... /init.d/mysql.server s99mysql