Shulou(Shulou.com)05/31 Report--

This article mainly explains "how linux shuts down mysql". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how linux shuts down mysql".

The method that linux closes mysql: 1, open terminal command window; 2, close mysql by executing "/ usr/local/mysql/bin/mysqladmin shutdown" command.

This article operating environment: windows7 system, mysql version 5.7, Dell G3 computer.

How does linux shut down mysql?

Linux starts and shuts down MySQL

It is recommended to start with the mysqld_safe command because it adds a security feature that automatically restarts when an error occurs on the server and sends running information logging errors to the log file! The format of the command is as follows:

Mysqld_safe options

Common options for commands are described as follows:

-- directory location of datadir=path data files

-- help displays help information for commands

-- log-err=file_name records the error message to the specified file

-- nice=priority executes mysql process priority

-- open-files-limit=count sets the maximum number of files that mysql allows to open

-- pid-file=file_name sets the location of the process ID file

-- port=number sets the listening port of the mysql server

-- usr= {user_name | user_id} specifies the user running the mysql process

one hundred and one

Start MySql

/ usr/local/mysql/bin/mysqld_safe &

# check the mysql process

Ps-ef | grep mysql

Close Mysql

The # kill-9 command cannot kill the mysql process because mysqld_safe automatically restarts the correct shutdown command as follows:

/ usr/local/mysql/bin/mysqladmin shutdown

Check mysql service status

/ usr/local/mysql/bin/mysqladmin status Thank you for your reading, the above is the content of "how linux shuts down mysql". After the study of this article, I believe you have a deeper understanding of how linux shuts down mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.