MYSQL PORT 3306

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

MYSQL PORT 3306

Postby dogdomain » 21. September 2017 19:13

MySQL set for port 3306. How do I change the port or how do I find out what app is using port 3306 already?????
dogdomain
 
Posts: 7
Joined: 16. September 2017 21:20
XAMPP version: v3.2.2
Operating System: msi10

Re: MYSQL PORT 3306

Postby Altrea » 21. September 2017 20:28

dogdomain wrote:how do I find out what app is using port 3306 already?????

Use the XAMPP control panel netstat button, or use Windows Ressourcemonitors network tab, or use third party program TCPView, or send a "netstat -aon|find ":3306"" command to get the PID (process ID) and find that PID in your windows task manager processes tab... there are many ways.
Very common this will be another MySQL or MariaDB installation. 3306 is not known for any other famous program tend to use.
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: 8969
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MYSQL PORT 3306

Postby dogdomain » 22. September 2017 21:20

How do I change the 3306 port for MySQL win 10 please. I have found several help, but still cannot get it done. I tried one and did as they say and it would not change to 3307.
dogdomain
 
Posts: 7
Joined: 16. September 2017 21:20
XAMPP version: v3.2.2
Operating System: msi10

Re: MYSQL PORT 3306

Postby Altrea » 22. September 2017 23:52

Take a look into your \xampp\mysql\bin\my.ini file. Should not be that difficult to search and replace the 2 occurrences of the number 3306.
After that you will also need to change phpMyAdmins configuration too to connect on the correct port.

But i still recommend to find out which other program is occupying port 3306 and stop this program.
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: 8969
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: Anancuras\ and 41 guests