Change MYSQL Port from 3306 to 3307

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Change MYSQL Port from 3306 to 3307

Postby shakedown21 » 20. August 2015 22:23

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
shakedown21
 
Posts: 4
Joined: 20. August 2015 22:11
Operating System: Windows 7 Pro

Re: Change MYSQL Port from 3306 to 3307

Postby Altrea » 20. August 2015 22:41

Did you change the Port in The control panel settings too?
Full control panel log window contents is needed
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Change MYSQL Port from 3306 to 3307

Postby shakedown21 » 20. August 2015 23:40

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.
shakedown21
 
Posts: 4
Joined: 20. August 2015 22:11
Operating System: Windows 7 Pro

Re: Change MYSQL Port from 3306 to 3307

Postby shakedown21 » 20. August 2015 23:44

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
 
Posts: 4
Joined: 20. August 2015 22:11
Operating System: Windows 7 Pro

Re: Change MYSQL Port from 3306 to 3307

Postby Altrea » 21. August 2015 01:41

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Change MYSQL Port from 3306 to 3307

Postby shakedown21 » 22. August 2015 23:06

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.
shakedown21
 
Posts: 4
Joined: 20. August 2015 22:11
Operating System: Windows 7 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests