本地搭建网站时,我们总会遇到些问题,今天黄俊生为大家分享个,我用XAMPP软件搭建网站时出现的错误:XAMPP – MySQL shutdown unexpectedly,我是怎么解决的,希望能解决到你的问题。
关于MySQL启用失败,出现了如下情况:
XAMPP – MySQL shutdown unexpectedly
14:39:04 [mysql] Status change detected: running
14:39:05 [mysql] Status change detected: stopped
14:39:05 [mysql] Error: MySQL shutdown unexpectedly.
14:39:05 [mysql] This may be due to a blocked port, missing dependencies,
14:39:05 [mysql] improper privileges, a crash, or a shutdown by another method.
14:39:05 [mysql] Press the Logs button to view error logs and check
14:39:05 [mysql] the Windows Event Viewer for more clues
14:39:05 [mysql] If you need more help, copy and post this
http://www.huangjunsheng.net/aiseo/598.html
关于MySQL启用失败,出现了如下情况:
XAMPP – MySQL shutdown unexpectedly
14:39:04 [mysql] Status change detected: running
14:39:05 [mysql] Status change detected: stopped
14:39:05 [mysql] Error: MySQL shutdown unexpectedly.
14:39:05 [mysql] This may be due to a blocked port, missing dependencies,
14:39:05 [mysql] improper privileges, a crash, or a shutdown by another method.
14:39:05 [mysql] Press the Logs button to view error logs and check
14:39:05 [mysql] the Windows Event Viewer for more clues
14:39:05 [mysql] If you need more help, copy and post this
14:39:05 [mysql] entire log window on the forums
我的解决方法是:(这里以我的真实案例操作)
1.找到本地磁盘D:存放xampp的文件夹,点击打开文件夹;
2.找到Mysql文件夹,点击打开;
3.找到data文件夹,点击打开;
4.找到 ibdata1 这个文件,并删除它;
5.重新启用MYSQL,启动成功。显示:
15:51:03 [mysql] Attempting to start MySQL app…
15:51:03 [mysql] Status change detected: running
如果你也是出现了这种MYSQL运行失败的情况,这个教程肯定能给你解决掉这个问题!
注意:原来的数据库数据表就丢失,在删除前最好备份保留
http://www.huangjunsheng.net/aiseo/598.html