时间戳

首页 > 解决方案 > MySQL 未在 XAMPP 中启动（错误：MySQL 意外关闭...）

mysql - MySQL 未在 XAMPP 中启动（错误：MySQL 意外关闭...）

问题描述

我已经在 Windows 10 上安装了 XAMPP，但 MySQL 没有启动。为什么？

我已经尝试使用任务管理器查看是否有另一个 MySQL 正在运行，但没有。我试图改变端口，但没有。请帮忙。

图片：

在此处输入图像描述

这是日志：

2019-04-27 11:53:56 12060 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-04-27 11:53:56 12060 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-04-27 11:53:56 12060 [Note] InnoDB: The InnoDB memory heap is disabled
2019-04-27 11:53:56 12060 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-04-27 11:53:56 12060 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-04-27 11:53:56 12060 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-04-27 11:53:56 12060 [Note] InnoDB: Using generic crc32 instructions
2019-04-27 11:53:56 12060 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-04-27 11:53:56 12060 [Note] InnoDB: Completed initialization of buffer pool
2019-04-27 11:53:56 12060 [Note] InnoDB: Restoring page 0 of tablespace 0
2019-04-27 11:53:56 12060 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2019-04-27 11:53:56 12060 [ERROR] InnoDB: space header page consists of zero bytes in data file \xampp\mysql\data\ibdata1
2019-04-27 11:53:56 12060 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2019-04-27 11:53:56 12060 [ERROR] Plugin 'InnoDB' init function returned error.
2019-04-27 11:53:56 12060 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-04-27 11:53:56 12060 [Note] Plugin 'FEEDBACK' is disabled.
2019-04-27 11:53:56 12060 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-04-27 11:53:56 12060 [ERROR] Aborting

标签： mysql

解决方案

从您的目录中删除并重ib_logfile0试。那应该有帮助。ib_logfile1MySQL

推荐阅读