Summary: in this tutorial, you will learn how to stop MySQL Server on Windows and Linux.
Stop MySQL Server on Windows
If you install MySQL Server as a service on Windows, you can stop it as follows:
First, press Windows+R
to open the Run
dialog.
Second, input cmd and press Ctrl+Shift+Enter
to run the Command Prompt as an Administrator.
Third, type the following command to stop the MySQL Server:
net stop mysql
In this command, mysql
is the name of the MySQL service. If you use a different service name, you must replace mysql
with it.
The command shows the following output:
The MySQL service is stopping.
The MySQL service was stopped successfully.
Stop MySQL Server on Linux
To stop MySQL Server on Linux, you follow these steps:
First, open a Terminal program.
Second, run the following command to stop the MySQL service:
sudo systemctl stop mysql
In this command, you must replace mysql
with the actual service name if your MySQL service is different.
To check the status and confirm that the service has stopped, run the following command:
sudo systemctl status mysql
If you have stopped the service successfully, you should see “Active: inactive (dead)
“.
Summary
- Use the
net stop <mysql_service>
command to stop MySQL server on Windows. - Use the
sudo systemctl stop mysqld
command to stop the MySQL server on Linux.