xampp 启动后mysql 报 Error: MySQL shutdown unexpectedly. 错误

转向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/ 路径下面,就可以解决这个问题

评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值