Shulou(Shulou.com)06/01 Report--

Editor to share with you how mysql shuts down the server. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql shuts down the server: 1. Under windows, the code is [cd c:\ mysql\ bin;mysqladmin-uroot shutdown]; 2. Under linux, the code is [service mysql stop].

How mysql shuts down the server:

Under windows: how mysql shuts down the server

Start: 1.cd c:\ mysql\ bin 2.mysqld-- console close: 1.cd c:\ mysql\ bin 2.mysqladmin-uroot shutdown can also: start: 1.cd c:\ mysql\ bin 2.net start mysql close: 1.cd c:\ mysql\ bin 2.net stop mysql

Under linux:

Use netstat-nlp to check the status of the mysql service command line: on. / mysqld_safe & close mysqladmin-uroot shutdown rpm install on service mysql start close service mysql stop when starting mysql on the command line, if you don't add "--console", the startup and shutdown information is not displayed in the interface, but recorded in the data directory under the installation directory. The file name is generally hostname.err, through which you can view the console information of mysql.

Execute the command:

1.mysql/bin > mysql-u root-p test

Mysql-u root-p and then enter the password mysql > use testmysql > source c:/test.sqlwindows and linux both can use the file path is recommended to use / instead of\ read this article, I believe you have some understanding of mysql server shutdown methods, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.