Cannot connect MySQL to XAMPP

Question

I am trying to connect my MySQL database to XAMPP. Whenever I try to press start MySQL on XAMPP, it will not run and I get an error:

Port 3306 in use by "Unable to open process"!
MySQL WILL NOT start without the configured ports free!
You need to uninstall/disable/reconfigure the blocking application
or reconfigure MySQL and the Control Panel to listen on a different port

Could this be because of my virus protection software or VPN? How would I go about changing the ports in MySQL and Control Panel? If anyone could offer me some advice or direct me to an already answered question that is similar to this, it would be much appreciated. Thank you.

rpm192 · Answer 1 · 2018-12-09T20:14:10.117

2

You will need to change the port or find the process that's using it to stop it from doing that.

Changing the port is the easiest solution.

You will need to specify in your future applications that the port is something else than 3306 because it will assume that it's 3306 by default and cause your application to not work.

You can do the following to find out which process is using the specified port:

Open a command prompt (with elevated priviliges (as admin)) and run the following command: netstat -a -b

This will pump out a list of all the processes and the associated ports.

You can also put it into a textfile like so: netstat -a -b > myFile.txt

Switching the port mysql uses:

As the error suggests, the port 3306 is being used by some other process on your system.

The easiest way to fix this will be by switching it to a different port.

You can do this by opening your XAMPP control panel and clicking on "Config" next to the mysql button. After that, click my.ini.

After that, in the text file, edit the port to whatever you wanna use.

edited Dec 09 '18 at 20:14

answered Dec 09 '18 at 20:09

rpm192

2,630
3
20
38

And I can set it to just any old port? I tried 8080 and it doesn't work. I don't really know much about ports and TCP/IP – GovernorDynamic Dec 09 '18 at 20:14
1

Doesn't matter whatsoever, I'd suggest trying 3307 because it's easier to remember. – rpm192 Dec 09 '18 at 20:14
3307 did not work. I ran `netstat -b -p TCP` in CMD and it doesn't even show me that something is using port 3306. I'm so confused and frustrated. This is for a final project due tomorrow and I can't continue to test or finish it until i get this done. – GovernorDynamic Dec 09 '18 at 20:19
Hm, weird. Did you restart the control panel after changing it? – rpm192 Dec 09 '18 at 20:26
Yes. Multiple times. Now XAMPP won't even run and I have the port set to the default 80. I'm going to uninstall and reinstall. – GovernorDynamic Dec 09 '18 at 20:47
Still no luck. Could it be that I download MySQL and MySQL Server months ago and only just downloaded XAMPP with MySQL? Perhaps there are two instances of MySQL trying to access the same port and XAMPP can't connect to either? – GovernorDynamic Dec 09 '18 at 21:07
I GOT IT! See here: https://stackoverflow.com/questions/18177148/xampp-mysql-does-not-start – GovernorDynamic Dec 09 '18 at 21:10
Thank you for your help! – GovernorDynamic Dec 09 '18 at 21:10
1

Didn't see your comment about the second instance of mysql. Glad you got it working and good luck with your project. – rpm192 Dec 09 '18 at 21:22
I didn't even realize to mention it. Thank you! – GovernorDynamic Dec 09 '18 at 21:43

score 0 · Answer 2 · answered Dec 09 '18 at 20:42

0

Now that you have done everything, you then have to click on Config and then->Service and Port Settings. Change Main Port to 8080 also. On your browser, remember to use localhost:8080 rather than just local host.

answered Dec 09 '18 at 20:42

Twista

241
3
11

Cannot connect MySQL to XAMPP

2 Answers2