Apache Friends Support Forum

Hello -

I am trying to change the port that MYSQL uses because the server computer that I am trying to install XAMPP on, is already running MYSQL through port 3306. The service cannot be stopped as it is needed by our office. I have searched the internet for how to change it and followed all the directions. I went through all the files and wherever it mentioned port 3306, I changed it to 3307. Still no luck. MYSQL will not run in XAMPP. I get a port error message in XAMPP. Apache starts and runs fine.

Has anyone been successful at changing the port? If so, can you please provide some direction?

My System: Windows 7 Pro, 16GB RAM, Asus Z97WS Mother Board, Samsung 850EVO SSD

These are the basic directions that most forums recommend.
Edit the value to "port" in
xampp/mysql/bin/my.ini
Code:
# Password = your_password
port = 3306 ---> 3307
socket = "/ xampp / mysql / mysql.sock"

and here also

Code:
# The MySQL server [ mysqld ]
port = 3306 ---> 3307
socket = "/ xampp / mysql / mysql.sock"

2. Start mysql service

Did you change the Port in The control panel settings too?
Full control panel log window contents is needed

Hi -

Thank you for your response. I went through every config file I could find and searched each one for port 3306 and changed it to 3307. There were about 4 different files. When you say control panel panel settings are you referring to the C:/xampp Xampp-control - yes I changed it there too.

Does installing xampp on the same drive that the other mysql is running on, make a difference? I have two other hard drives on the computer, would installing xampp on one of the other drives solve the problem?

shakedown21 wrote:Does installing xampp on the same drive that the other mysql is running on, make a difference?

no

shakedown21 wrote:I have two other hard drives on the computer, would installing xampp on one of the other drives solve the problem?

no

I was finally able to change the port from 3306 to 3307. There were a number of files that needed to be changed. My next issue was that my computer was running MySQL server 5.5. For some reason xampp does not work with it. As soon as I removed it, everything worked fine. And xampp will work with MySQL server 5.5.46 the updated version.