Mysql 端口已被使用 [英] Mysql port already in use

问题描述

180718 12:43:04 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
180718 12:43:04 [ERROR] Do you already have another mysqld server running on port: 3306 ?
180718 12:43:04 [ERROR] Aborting

有什么解决办法吗?Mysql 在基于 Windows 的服务器上运行.请给出最佳解决方案..

is there any solution for it? Mysql is running on windows based server. Please give the best solution..

推荐答案

MySQL 的第二个实例或其他服务正在端口 3306 上运行.

Either a second instance of MySQL or another service is running on port 3306.

您可以通过以下方式停止在端口 3306 上运行的服务

You can either stop the service which is running on port 3306 by

获取该服务的进程ID:

getting the process id of that service:

netstat -a -n -o | find "3306"

然后杀死该进程(例如，对于进程 ID 1234):

and then killing that process (e.g. for process id 1234):

taskkill /pid 1234 /f

或者在不同的端口上运行 MySQL.

or run MySQL on a different port.

这篇关于Mysql 端口已被使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！