MySQL启动错误-端口已在使用中 [英] MySQL startup error - port is already in use

问题描述

尝试启动XAMPP时出现以下错误:

I get the following error while trying to start XAMPP:

12:34:26 PM  [mysql]    Attempting to start MySQL service...
12:34:38 PM  [mysql]    Problem detected!
12:34:38 PM  [mysql]    Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL"!
12:34:38 PM  [mysql]    MySQL WILL NOT start without the configured ports free!
12:34:38 PM  [mysql]    You need to uninstall/disable/reconfigure the blocking application
12:34:38 PM  [mysql]    or reconfigure MySQL and the Control Panel to listen on a different port
12:34:38 PM  [mysql]    Attempting to start MySQL service...

推荐答案

日志明确指出另一个应用程序正在监听端口3306，因此无法启动MySQL，因为3306是为其配置的端口(默认端口为MySQL连接).这个已经在por 3306上侦听的应用程序是MySQL的另一个实例，该实例可能已配置为自动启动.

The log cleraly states that another application is listening on port 3306, so it is not possible to start MySQL since 3306 is the configured port for it (default port for MySQL connections). This application that already listens on por 3306 is another instance of MySQL that's probably configured to start automatically.

如果使用Windows，请单击Start按钮，然后单击Execute，然后键入services.msc，然后按[Enter].查找正在运行的MySQL服务，将其停止，然后对其进行配置，以防止其在系统启动时启动.之后，您应该正常启动XAMPP.

If you are using Windows, click the Start button, then Execute, then type services.msc and press [Enter]. Look for the running MySQL service, stop it, and configure it to prevent its launching on system startup. After that you should start XAMPP normally.

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