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

This article mainly introduces "what is the method of starting and shutting down MySQL". In daily operation, I believe that many people have doubts about the method of starting and shutting down MySQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the method of starting and shutting down MySQL?" Next, please follow the editor to study!

I. Windws system-- start MySQLnet start mysql-- and shut down MySQLnet stop mysql

II. Linux system 1.service command-- disable mysql service service mysql stop-- start mysql service service mysql start-- restart mysql service service mysql restart

2. / etc/init.d/mysql

This command is the same as the server command of 1.

-- shut down mysql service / etc/init.d/mysql stop-- start mysql service / etc/init.d/mysql start3.mysqld command-- start mysql service mysqld-- user=root &

In fact, this is not recommended. My test environment uses mysql installed by root. I personally suggest changing root to mysql installation users. This place is for testing only.

The 4.mysqld_safe command mysqld_safe is a shell script that calls mysqld to start the mysql server and listens to the server. If the mysqld process terminates abnormally, mysqld_safe will automatically restart mysqld-- start the mysql service mysqld_safe-- defaults-file=/etc/my.cnf-- user=mysql &

5.mysqld_multi command this command is used when multiple msyql instances exist on a server-- multi-instance startup mysqld_multi start-- multi-instance shutdown mysqld_multi stop6.mysqladmin command

The mysqladmin command is the recommended secret order for shutting down the mysql service

-- disable the mysql service mysqladmin-uroot-p-S / var/lib/mysql/mysql.sock shutdown

7. Killing process killall mysqldkillall-9 mysqld so far, the study on "what is the method of starting and shutting down MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.