How to start mysql

MySQL is the most popular open source SQL database management system and a relational database management system. Relational databases store data in different tables. This article will introduce to you, How to start or stop the MySQL service on Windows and Linux systems.

Recommended learning reference: "mysql tutorial"

1. Windows mysql startup

1. Find the computer icon on the desktop, right-click the mouse, and open management tools->Services, as shown below.

2. In the services window, find and select the MySQL service.

If the MySQL service is running, you will see the following 3 options next to it.

Stop Service: This option will stop the selected service.

Pause service: This option will pause the selected service.

Restart Service: This option will restart the selected service.

To stop, pause or restart a service, just click on the corresponding option.

3. If mysql is not enabled in the service, which means that the MySQL service is originally stopped, you will only get the start service option, then you only need Just click Start.

4. By performing the above steps, you can also stop/start other Windows services.

2. Linux mysql startup

In Linux VPS, you can stop/start the MySQL service through SSH or WHM control panel.

Stop/Start MySQL Service via SSH/Terminal

Connect to the VPS via SSH using the root user and type the following commands.

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 Linux VPS services, you can use the above command by putting the service name. Here are some of the most common Linux VPS services.

exim // Mail 服务

httpd // Apache Web 服务

named // DNS 服务

sshd // SSH 服务

ftpd // FTP 服务

Start/stop the 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 checkbox 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 checkbox under the mysql and Save buttons.

5.Follow the above steps, you can also stop/start other listed services.

This article is about the steps to start the mysql service on Windows and Linux systems. I hope it will be helpful to friends in need!

The above is the detailed content of How to start mysql. For more information, please follow other related articles on the PHP Chinese website!