Click here to Skip to main content
15,907,913 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
from the last day i facing various problem. first my port 80 was busy. i found that skype also use port 80 then i fix it. bt now port 3306 is always busy. thats why i can't run mysql....please help me...wamp server also facing the same problem
Posted

Use TCPView[^] for example and identify the application that is using the port.
But you can use another port for MySQL if you wish, see: http://rajeshstutorials.blogspot.hu/2012/04/change-mysql-port-in-wampserver.html[^], but remember to change the port in php ini mysql section[^] too, or set the port parameter when you connect to it from code.
 
Share this answer
 
v2
This means an instance of your sql is already running.

To find out what program is running on all port run following command.
C:\>netstat -a

this will show list of all programs listening on different ports.
Find ProcessID(pid) of the program running on port 3306.
(if not showing Run cmd as Administrator)

now you need to kill this process.
to kill the process use following command...
C:\kill [pid of process];



Hope This Help You
-----------------------
Pratik Bhuva
 
Share this answer
 
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900