How to correctly restart the mysql server

It is incorrect for many friends to restart mysql directly at the end of the process. I will summarize how to correctly restart the mysql server.

It is incorrect for many friends to restart mysql directly at the end of the process. I will summarize how to correctly restart the mysql server.

How to restart mysql in windows-> Run-> cmd

Stop: net stop mysql

Start: net start mysql

If MYSQL is installed as a windows service

Wind method 2

Start-run-input: services. msc-click OK-find MySQL-right-click above-restart. That's all.

Linux

RedHat Linux (Fedora Core/Cent OS)
1. start:/etc/init. d/mysqld start
2. stop:/etc/init. d/mysqld stop
3. restart:/etc/init. d/mysqld restart
Debian/Ubuntu Linux
1. start:/etc/init. d/mysql start
2. stop:/etc/init. d/mysql stop
3. restart:/etc/init. d/mysql restart
Windows
1. Click Start> Run (shortcut: Win + R)
2. Start: Enter net stop mysql
3. Stop: Enter net start mysql
Prompt
Redhat Linux also supports service command,
Start: # service mysqld start
Stop: # service mysqld stop
Restart: # service mysqld restart
In Windows, you cannot directly restart (restart). You can only stop the instance and start it again. ......

Recommended secure Restart Method

$ Mysql_dir/bin/mysqladmin-u root-p shutdown
$ Mysql_dir/bin/mysqld_safe &

Mysqladmin and mysqld_safe are located in the bin directory of the Mysql installation directory.