Solution to the problem that MySQL service cannot be stopped or deleted under Windows

I installed MySQL on Windows by unzipping the compressed package. Here is how to install it: Click here. When executing the following command:

mysqld --install MySQL --defaults-file=[absolute path to the ini configuration file]

When executing the above command, an incorrect configuration file path was entered. Although the system may return success. And the command mysqld --initialize can also be executed and generate data files. But when I execute net start mysql, the system will always prompt that the service is starting. The reason is that my configuration file path is wrong, which causes abnormalities when the service is started. At this time, the MySQL service cannot be started and cannot be stopped through the command line and control panel. The MySQL service also cannot be deleted.

Solution:

Control Panel → Select Large Icons in the upper right corner → Administrative Tools → Services → Select MySQL.

At this time you can see that there is no option to stop, restart or pause. This is what you need to do:

Right-click the MySQL service → Properties → General tab → Select Disable in "Startup type" → Restart the computer → Open the command line as an administrator → Use the cd command to enter the bin folder under the MySQL installation path.

Because the MySQL service is set to prohibit startup at boot, and the computer is restarted, the MySQL service is stopped at this time.

Enter the command on the command line:

mysqld remove MySQL

The command can be executed normally, and after the command is executed, the incorrectly configured MySQL service can be deleted. Then delete all the files under the MySQL data folder and reinstall MySQL step by step from scratch.

The above is the solution to the problem that the MySQL service cannot be stopped and deleted under Windows introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!