MySQL is an open-source relational database management system, which is widely used in various scenarios, such as development and data storage. Under the Windows operating system, we can start the MySQL service by following the following steps:
1. Install MySQL
First of all, we need the MySQL installation package. Visit MySQL Official ** (www.).mysql.com) ** The installation package of the corresponding version.
*When you're done, double-click on the installation package to enter the installation wizard. Follow the prompts and select the installation type, path, and other information.
During installation, you will be prompted to set the password of the root user of MySQL. Make sure that the password is complex enough to keep the database secure.
Once the installation is complete, click on the "Done" button and MySQL will be launched automatically.
2. Start the MySQL service.
Press the "Win + R" key combination on your keyboard to open the "Run" window. Enter servicesmsc" and press Enter.
In the pop-up Services window, find the service named MySQL. If the service name contains "80" (or other numbers), the default port for MySQL is 80 (or other numbers).
Right-click the MySQL service and choose Start. At this point, the MySQL service will start running.
If you need to check whether the MySQL service is running properly, you can open the command prompt (win + r, enter cmd, and press enter).
If the service is functioning normally, the command prompt will say "The service started successfully".
3. Connect to MySQL
Open a client tool that supports MySQL, such as MySQL Workbench, N**iCAT, etc.
In Client Tools, enter the following information:
Hostname: localhost (or 127.)0.0.1）
Port number: 3306 (or other numbers, depending on the actual setting) by default
Username: root (or other user with permissions).
Password: the password of the MySQL root user that you set earlier.
Click the "Connect" button and try to connect to the MySQL server. If the connection is successful, the client tool displays a list of databases in the server.
4. Disable the MySQL service.
Press the "Win + R" key combination on your keyboard to open the "Run" window. Enter servicesmsc" and press Enter.
In the pop-up Services window, find the service named MySQL. Right-click the MySQL service and choose Stop. In this case, the MySQL service stops running.
Through the above steps, we can start and stop the MySQL service under the Windows operating system. During use, if you encounter problems, you can refer to the official documentation or seek community help.