转向xampp后,如果不把mysql启动为服务,启动成功;如果把mysql加为服务后,启动就会报错误
Error: MySQL shutdown unexpectedly.
9:48:30 [mysql] This may be due to a blocked port, missing dependencies,
9:48:30 [mysql] improper privileges, a crash, or a shutdown by another method.
9:48:30 [mysql] Press the Logs button to view error logs and check
9:48:30 [mysql] the Windows Event Viewer for more clues
9:48:30 [mysql] If you need more help, copy and post this
9:48:30 [mysql] entire log window on the forums
在mysql错误日志中,报错为
131217 9:49:59 [Note] Plugin 'FEDERATED' is disabled.
131217 9:49:59 InnoDB: The InnoDB memory heap is disabled
131217 9:49:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131217 9:49:59 InnoDB: Compressed tables use zlib 1.2.3
131217 9:49:59 InnoDB: Initializing buffer pool, size = 16.0M
131217 9:49:59 InnoDB: Completed initialization of buffer pool
131217 9:49:59 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!
131217 9:49:59 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
解决方法是打开my.ini文件,将里面的/xampp/路径更换为 盘符:/xampp/ 路径,比如说我的是 I:/xampp/ 路径下面,就可以解决这个问题