This article will assist you to stop and start MySQL service from Windows VPS and VPS Hosting.
Windows VPS
1. Log in to your Windows VPS through Remote Desktop. Please refer to connect VPS using RDP for more details.
2. Go to Start >> Administrative Tools >> Services.
3. At the Services Window, locate and select MySQL service.
4. If MySQL service is running, you will get the following 3 options on the right side.
- Stop the service // This option will stop the selected service.
- Pause the service // This option will pause the selected service.
- Restart the service // This option will restart the selected service.
5. To Stop, Pause, or Restart the service, click on the respective option.
6. If MySQL service is stopped, you will get only the option to Start the service, as shown in the following image.
7. By following the above steps, you can also stop/start other Windows Services.
VPS Hosting
In VPS Hosting, you can stop/start MySQL service either through SSH or WHM control panel.
Stop/start MySQL service through SSH/Terminal
Connect to your VPS through SSH with the root user and type the following commands. Please refer to connect VPS using SSH for more details.
Stop MySQL
service mysql stop OR /etc/init.d/mysql stop
Start MySQL
service mysql start OR /etc/init.d/mysql start
Restart MySQL
service mysql restart OR /etc/init.d/mysql restart
Check MySQL server status
service mysql status
If you want to stop/start other VPS Hosting services, you can use the above commands by placing the service name. Following are some of the most common VPS Hosting services.
exim // Mail Server
httpd // Apache Web Server
named // DNS Server
sshd // SSH Service
ftpd // FTP Server
Start/Stop MySQL service through WHM
1. Log in to WHM (https://your-IP-address:2087).
2. Under the Service Configuration section, select Service Manager.
3. Uncheck the check boxes under MySQL and click the Save button. This will stop MySQL service.
4. To start MySQL service, you just need to check the checkboxes under MySQL and click the Save button.
5. By following the above steps, you can also stop/start other listed services.
