2014.04.17 今天在xampp中启动mysql启动不了，点start之后变绿之后又停止了，而前面一直是正常的。我首先马上检查是不是有端口占用，但是没有占用。然后我又网上大量搜索资料查看，但是也没有找到对口的解决办法。然后我在自己同步的笔记本上启动，是可以启动的，于是我通过beyond compare比较，查看启动不了时给出的log记录： 140417 12:28:08 [Note] Plugin ‘FEDERATED’ is disabled. 140417 12:28:08 InnoDB: The InnoDB memory heap is disabled 140417 12:28:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions 140417 12:28:08 InnoDB: Compressed tables use zlib 1.2.3 140417 12:28:08 InnoDB: Initializing buffer pool, size = 16.0M 140417 12:28:08 InnoDB: Completed initialization of buffer pool 140417 12:28:08 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140417 12:28:08  InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 140417 12:28:09  InnoDB: Waiting for the background threads to start 140417 12:28:10 InnoDB: 1.1.8 started; log sequence number 640076454 140417 12:28:10 [ERROR] Can’t start server: Bind on TCP/IP port: No such file or directory 140417 12:28:10 [ERROR] Do you already have another mysqld server running on port: 3306 ? 140417 12:28:10 [ERROR] Aborting 140417 12:28:10  InnoDB: Starting shutdown… 140417 12:28:11  InnoDB: Shutdown completed; log sequence number 640076454 140417 12:28:11 [Note] mysql\bin\mysqld.exe: Shutdown complete 根据这个记录，其中显示[ERROR] Do you already have another mysqld server running on port: 3306 ?，我就再次检查端口是否被占用，但是确实没有找到被占用。然后我注意到“InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery.”，看来是前面数据库没有正常关闭，通过搜索这句话，参照网上的资料进行了操作，解决了问题，参考：“下面命令是正常关闭MYSQL的命令 “D:\mysql5\bin\\mysqladmin” shutdown -uroot -p” 可正常启动了 140417 12:46:58 [Note] Plugin ‘FEDERATED’ is disabled. 140417 12:46:58 InnoDB: The InnoDB memory heap is disabled 140417 12:46:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions 140417 12:46:58 InnoDB: Compressed tables use zlib 1.2.3 140417 12:46:58 InnoDB: Initializing buffer pool, size = 16.0M 140417 12:46:58 InnoDB: Completed initialization of buffer pool 140417 12:46:58 InnoDB: highest supported file format is Barracuda. 140417 12:46:59  InnoDB: Waiting for the background threads to start 140417 12:47:00 InnoDB: 1.1.8 started; log sequence number 640076454 140417 12:47:01 [Note] Event Scheduler: Loaded 0 events 140417 12:47:01 [Note] mysql\bin\mysqld.exe: ready for connections. Version: ‘5.5.16’  socket: ‘’  port: 3306  MySQL Community Server (GPL)