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 the MySQL service.
4. If the 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 the 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 the 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
systemctl stop mysqld OR /etc/init.d/mysql stop
Start MySQL
systemctl start mysqld OR /etc/init.d/mysql start
Restart MySQL
systemctl restart mysqld OR /etc/init.d/mysql restart
Check MySQL server status
systemctl status mysqld
If you want to stop/start other VPS Hosting services, you can use the above commands by placing the service name. The 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 the MySQL service.
4. To start the 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.
Conclusion
Managing the MySQL service is an essential administrative task for maintaining database performance, applying configuration changes, and troubleshooting issues on both Windows and Linux VPS environments. Whether you are using a Windows VPS through the Services console, a Linux VPS via SSH commands, or WHM for cPanel-based servers, stopping, starting, or restarting MySQL can be done quickly and safely by following the steps outlined above.
Always ensure that MySQL is restarted during low-traffic periods to avoid service disruption, and verify the service status after making any changes. With proper control over MySQL services, you can maintain a stable and efficient database environment for your applications and websites.
