In this article, we have explained how to start stop restart mysql server on Windows step by step.
We can start, stop mysql server using following 4 methods.
1. Using services.msc 2. using net command from command prompt 3. using mysqladmin from command prompt(With this we can only shutdown the MySQL server 4. From MySQL Workbench.
Method 1: Using services.msc
Open services.msc app by Windows+R and type services.msc and enter.
Select the MySQL service ‘MySQL80’ Right click and select to stop to, restart to restart MySQL server on windows.
Method 2: using net command from command prompt
1. Open command prompt as administrator.
2. Then click run the below command to stop MySQL server.
Following command is to stop MySQL 8 version. For other versions go to services and check the service name.
net stop MySQL80
To start MySQL server use below command.
net start MySQL80
Method 3: Using mysqladmin from command prompt(With this we can only shutdown the MySQL server
Change current directory to MySQL bin directory C:\Program Files\MySQL\MySQL Server 8.0\bin.
Now run the below command to shutdown MySQL from command prompt using mysqladmin tool.
mysqladmin -u root -p shutdown
Method 4. From MySQL Workbench.
1. Open MySQL Workbench
2. Then click Startup/Shutdown from left menu. Then, click stop server to stop MySQL Server.
3. If we want to start, then click Start Server and provide password.
So in this article we have seen how to start stop and restart MySQL server on Windows with different methods.