XAMPP MySQL在启动时不工作

Question

10:01:04 PM  [mysql]    Error: MySQL shutdown unexpectedly.
10:01:04 PM  [mysql]    This may be due to a blocked port, missing dependencies, 
10:01:04 PM  [mysql]    improper privileges, a crash, or a shutdown by another method.
10:01:04 PM  [mysql]    Press the Logs button to view error logs and check
10:01:04 PM  [mysql]    the Windows Event Viewer for more clues
10:01:04 PM  [mysql]    If you need more help, copy and post this
10:01:04 PM  [mysql]    entire log window on the forums

当我尝试在xampp中启动MySQL时，我得到了这个错误。下面是mysql_error.log文件：

31127 21:56:14 [Note] Plugin 'FEDERATED' is disabled.
131127 21:56:14 InnoDB: The InnoDB memory heap is disabled
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
131127 21:56:15  InnoDB: Waiting for the background threads to start
131127 21:56:16 InnoDB: 5.5.32 started; log sequence number 22856689
131127 21:56:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131127 21:56:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
131127 21:56:16 [Note] Server socket created on IP: '0.0.0.0'.

谢谢!

Answer 1

它可能是MySQL正在尝试侦听的端口已被使用。您可以尝试进入命令提示符并运行netstat，以查看哪些程序正在使用哪些端口。

C:\> netstat -a -b