Shulou(Shulou.com)05/31 Report--

Today, what the editor shares with you is how to solve the problem that net start mysql can't start MySQL. I believe many people don't know much about it. In order to make you understand better, I summarized the following contents for you. Let's look down together. I'm sure you'll get something.

Problem description: typing "net start mysql" in the command prompt window will not start MySQL.

The system is Windows8.1,MySQL and the software is mysql-installer-community-5.7.12.0.

1.MySQL startup permission problem

(1) the following page appears during the installation of MySQL:

In the Root Account Password area of this page, the password we set is Root Password, which is a password corresponding to the administrator identity. We usually click Next directly after setting the password, instead of clicking "Add User" in the area below to set the average user, which makes it easy for us to forget that we should start MySQL with administrator privileges when we start MySQL.

(2) MySQL started without administrator privileges

Here's what happened when I started MySQL for the first time:

Operation: Win + R, enter cmd, start the command prompt window, enter "net start mysql".

Result: system error 5 occurred. Access denied.

(3) MySQL started with administrator privileges

To solve this problem, I used the command prompt window with administrator privileges.

Operation: WIN + X

Select the red box in the following figure:

Enter "net start mysql".

Result: the MySQL service has been started successfully.

Therefore, the solution to this problem is to use the command prompt (administrator).

2.MySQL service name problem

(1) the following page appears during the installation of MySQL:

Note: during installation, the name in the red box defaults to MySQL57 (corresponding to version 5.7), which I changed to "MySQL" at this time. The crux of the second question lies in this name.

The red box above means to name the MySQL program in the Windows system Services window. In other words, the name here is the same as the name of the service window. If we don't change "MySQL57" to "MySQL", we should type "net start mysql57" instead of "net start mysql" when we start the MySQL program at the command prompt.

(2) Windows system service window

The Windows system Services window is mentioned above, and let's talk about this window below.

Win+ R starts the running window, enter services.msc, and press enter, as shown in the following figure:

The service window is as follows, where the red box is the service name of each program.

Because I have changed "MySQL57" to "MySQL" during installation, my MySQL program is now named in the list of services as shown in the following figure.

This way, when I start MySQL with a prompt window, I can use "net start mysql" instead of typing "net start mysql57".

3. Summary

Start MySQL with administrator privileges at startup, and directly name the service name "MySQL" when you install MySQL.

How to solve the problem that net start mysql can't start MySQL is shared here. I hope the above content can be used as a reference for everyone. If you like this article, you might as well share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.