What are the MySQL startup and shutdown commands? (Summary sharing)

This article brings you relevant knowledge about the startup and shutdown commands of the MySQL database. Will different systems be different? Let's take a look at it together. I hope it will be helpful to everyone.

1.Windws system

--  启动MySQLnet start mysql-- 关闭MySQLnet stop mysql

##2.Linux system

1.service command

-- 关闭mysql服务service mysql stop-- 启动mysql服务service mysql start-- 重启mysql服务service mysql restart

2. /etc/init.d/mysql

This command is the same as the server command

-- 关闭mysql服务/etc/init.d/mysql stop-- 启动mysql服务/etc/init.d/mysql start

3.mysqld command

-- 启动mysql服务mysqld  --user=root &

In fact, it is not recommended to do this. My test environment uses mysql installed by root. I personally recommend changing root to the mysql installation user. This place is only for testing

4.mysqld_safe command

 mysqld_safe是一个shell 脚本，会调用mysqld启动mysql服务器，并监听服务器。
 如果mysqld进程异常终止，mysqld_safe将自动重启mysqld

    -- 启动mysql服务
    mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

5.mysqld_multi command

该命令是当一台服务器上存在多个msyql实例的时候使用

    -- 多实例启动
    mysqld_multi start
    --多实例关闭
    mysqld_multi stop

6.mysqladmin command

mysqladmin command is recommended to shut down the mysql service Secret command

 --关闭mysql服务mysqladmin -uroot -p -S /var/lib/mysql/mysql.sock shutdown

7. Kill the process

killall mysqld
killall -9 mysqld

8. Summary

The startup and shutdown commands of MySQL are much weaker than those of Oracle. A bit much

In fact, remember, use mysqld_safe to start the service in the production environment, and use mysqladmin to shut down the service.

Recommended learning:

mysql video tutorial

The above is the detailed content of What are the MySQL startup and shutdown commands? (Summary sharing). For more information, please follow other related articles on the PHP Chinese website!