Start/stop/restart MySQL server in command mode

Mysql can be run in linux and windows. Next we will introduce how to use command mode to start and stop the restart of MySQL server in windows, and then introduce the command to start and stop the restart of MySQL server in linux.

Mysql can be run in linux and windows. Next we will introduce how to start/stop/restart the MySQL server in command mode in windows, and then introduce the commands for starting/stopping/restarting the MySQL server in linux.

I. Startup Mode

1. start with service: service mysqld start

2. Use the mysqld script to start:/etc/init. d/mysql start

3. Start with safe_mysqld: safe_mysqld &

Ii. Stop

1. Start with service: service mysqld stop

2. Use the mysqld script to start:/etc/inint. d/mysqld stop

3. mysqladmin shutdown

3. Restart

1. Start with service: service mysqld restart

2. Use the mysqld script to start:/etc/inint. d/mysqld restart

3. Go to the bin/directory under the mysql installation directory:

Stop mysql:./mysqladmin-u-p shutdown

Start mysql:./mysqld_safe &

Linux Server restart, stop, start

For example, on Linux PPC, the directory is/etc/rc. d and/etc/rc. d/rc3.d. you can install the script like this:

The Code is as follows:
# Cp mysql. server/etc/rc. d/init. d # Cd/etc/init. d # Chmod 500 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 running level directory

Yes/etc/rd2.d, so the command looks like this:

The Code is as follows:
# Cp mysql. server/etc/rc. d/init. d # Cd/etc/init. d # Chmod 500 mysql. server # Cd/etc/rc2.d # Ln-s ../init. d/mysql. server S99mysql