MySQL port is occupied when building xampp

Problem description ： build xampp Tips mysql Port occupied . Here's the picture

reason ： A computer has been installed before mysql Not uninstalled .

terms of settlement ：

2 In this case ：1. Not previously installed mysql, Just change the port number directly .

                2. It's been installed before mysql And I'm not going to delete the old mysql, But switch to the new mysql： Change the registration form

In the first case ： Not previously installed mysql

Follow the steps below , stay xampp change mysql Configuration file for , Port number changed to ：3308 Or any unoccupied port

a. Click on congif==》 choice my.ini

b. Change the following image 2 Port number is 3308, Or other unoccupied ports

  For the second case ： It's been installed before mysql Don't want to uninstall , I also want to use the current mysql.

        step ： Change the default in the registry mysql Address .

        principle ： Change the default startup address of the registry from the old one mysql To the new mysql, This starts mysql When , Is to start a new mysql.

        Old address ：C:\Program Files\MySQL\MySQL Server 5.5\my.ini

        xampp New address ：C:\xampp\mysql\bin\mysqld

1. Open registry editor

2. find mysql Address HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL

3. Double-click to open , Change address ,defaults-file=‘ Delete the old address here , Change to a new address ’. I have xampp Of mysql The new address is C:\xampp\mysql\bin\mysqld, So it's like the picture below .

 

  result ：xampp It can start normally .