mysql意外关闭xampp_XAMPP-错误:MySQL意外关闭

bd96500e110b49cbb3cd949968f18be7.png

I have reinstalled XAMPP for some reason and MySQL is not working, giving the following error in the console:

01:56:03 [mysql] Error: MySQL shutdown unexpectedly.

01:56:03 [mysql] This may be due to a blocked port, missing dependencies,

01:56:03 [mysql] improper privileges, a crash, or a shutdown by another method.

01:56:03 [mysql] Check the "/xampp/mysql/data/mysql_error.log" file

01:56:03 [mysql] and the Windows Event Viewer for more clues

When checking the "/xampp/mysql/data/mysql_error.log" file I get:

130302 1:48:06 InnoDB: Waiting for the background threads to start

130302 1:48:07 InnoDB: 1.1.8 started; log sequence number 1600324627

130302 1:48:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

130302 1:48:07 [Note] - '0.0.0.0' resolves to '0.0.0.0';

130302 1:48:07 [Note] Server socket created on IP: '0.0.0.0'.

130302 1:51:12 [Note] Plugin 'FEDERATED' is disabled.

130302 1:51:12 InnoDB: The InnoDB memory heap is disabled

130302 1:51:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions

130302 1:51:12 InnoDB: Compressed tables use zlib 1.2.3

130302 1:51:12 InnoDB: Initializing buffer pool, size = 16.0M

130302 1:51:12 InnoDB: Completed initialization of buffer pool

130302 1:51:12 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!

130302 1:51:12 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...

130302 1:51:13 InnoDB: Waiting for the background threads to start

130302 1:51:14 InnoDB: 1.1.8 started; log sequence number 1600324627

130302 1:51:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

130302 1:51:14 [Note] - '0.0.0.0' resolves to '0.0.0.0';

130302 1:51:14 [Note] Server socket created on IP: '0.0.0.0'.

130302 1:56:01 [Note] Plugin 'FEDERATED' is disabled.

130302 1:56:01 InnoDB: The InnoDB memory heap is disabled

130302 1:56:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions

130302 1:56:01 InnoDB: Compressed tables use zlib 1.2.3

130302 1:56:01 InnoDB: Initializing buffer pool, size = 16.0M

130302 1:56:01 InnoDB: Completed initialization of buffer pool

130302 1:56:01 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!

130302 1:56:01 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...

130302 1:56:02 InnoDB: Waiting for the background threads to start

130302 1:56:03 InnoDB: 1.1.8 started; log sequence number 1600324627

130302 1:56:03 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

130302 1:56:03 [Note] - '0.0.0.0' resolves to '0.0.0.0';

130302 1:56:03 [Note] Server socket created on IP: '0.0.0.0'.

That is just a part of the log, the full one is a bit too big.

Help?

解决方案

Quit your skype and try, if skype is opne

or

Go to your xampp/wamp installed, search for httpd.conf.

Open that file using textpad/notepad, search for Listen or 80 ,

update listen port to 8081 and save the file.

Restart xampp/wamp, start the servers.

or

follow below steps in skype

RrUvT.jpg

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值