XAMPP solution for using MySQL port in a problem

If you have MySQL installedon your computer before you install Xampp , and you have added Windows services

Two MySQL conflicts in Windows services when using XAMPP

This means that you have used MySQL on your computer before, and the path and Port are occupied.

In this case, MySQL in XAMPP will not start normally,

A message like this will appear

First, try to change the port value in config of Xampp Mysql and control Panel settings, still error

Now try to prompt the second method of the message (if you have previously installed do not want to use it), this modification method in Baidu experience has a good solution

General idea:

cmd Open command line

SC query MySQL queries MySQL service status

SC delete MySQL delete mysql service

sc query MySQL query again, the following message appears to indicate that the deletion was successful

Output:

[SC] Enumqueryservicesstatus:openservice Failure 1060:

The specified service is not installed

Start XAMPP again to use both

The following is a detailed link

Resolves an issue where MySQL server fails to start in XAMPP

It uses the SC tool that comes with Windows

Note that the command is to be used under administrator privileges , in contrast:

Simply run cmd as administrator to,cmd-> right-click and run as Administrator

XAMPP solution for using MySQL port in a problem