端口3306无法正常工作 [英] port 3306 is not working
问题描述
使用TCPView [ ^ ]并识别正在使用该端口的应用程序。
但如果您愿意,可以使用另一个端口用于MySQL,请参阅: http://rajeshstutorials.blogspot.hu/2012/04/change- mysql-port-in-wampserver.html [ ^ ],但请记住在 php ini mysql section <中更改端口/ a> [ ^ ],或者从代码连接到它时设置port参数。
这意味着你的sql实例已经在运行。
要查看所有端口上正在运行的程序,请执行以下命令。
C:\> netstat -a
这将显示在不同端口上侦听的所有程序的列表。
查找在端口3306上运行的程序的ProcessID(pid)。
(如果没有显示以管理员身份运行cmd )
现在您需要终止此过程。
使用以下命令杀死进程...
C:\ kill [进程的pid];
希望这个帮助你
----------------- ------
Pratik Bhuva
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
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.
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
这篇关于端口3306无法正常工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!