时间戳

首页 > 解决方案 > MySQL shutdown unexpectedly xampp

php - MySQL shutdown unexpectedly xampp

问题描述

My apache is running properly but mysql server is showing this error

Error: MySQL shutdown unexpectedly.
[mysql] This may be due to a blocked port, missing dependencies, 
[mysql] improper privileges, a crash, or a shutdown by another method.
[mysql] Press the Logs button to view error logs and check
[mysql] the Windows Event Viewer for more clues
[mysql] If you need more help, copy and post this
[mysql] entire log window on the forums

I tried deleting ibdata1, ib_logfile0, ib_logfile1, ib_logfile101 files, but it didn't workout. Help me to solve this problem.

标签： phpmysqlphpmyadminxamppport

解决方案

我今天也面临同样的问题。

Error: MySQL shutdown unexpectedly.
7:56:51 PM  [mysql]     This may be due to a blocked port, missing dependencies, 
7:56:51 PM  [mysql]     improper privileges, a crash, or a shutdown by another method.
7:56:52 PM  [mysql]     Press the Logs button to view error logs and check
7:56:52 PM  [mysql]     the Windows Event Viewer for more clues
7:56:52 PM  [mysql]     If you need more help, copy and post this
7:56:52 PM  [mysql]     entire log window on the forums

解决方案：

  1. 停止 Apache 服务，然后

  2. 从 xampp\mysql\backup 复制所有文件，并将所有文件粘贴到 xampp\mysql\data 中。

  3. 启动阿帕奇

...并且 MySQL 运行良好。

推荐阅读