xammp启动MySQL时候报错，查询日志报如下信息：

[测试的小白]

InnoDB: using atomic writes.
2022-09-24 19:12:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-24 19:12:09 0 [Note] InnoDB: Uses event mutexes
2022-09-24 19:12:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-24 19:12:09 0 [Note] InnoDB: Number of pools: 1
2022-09-24 19:12:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-24 19:12:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-24 19:12:09 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-24 19:12:09 0 [Note] InnoDB: Header page consists of zero bytes in datafile: D:\Xampp\mysql\data\ibdata1, Space ID:0, Flags: 0
2022-09-24 19:12:09 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile 'D:\Xampp\mysql\data\ibdata1' could not be found in the doublewrite buffer.
2022-09-24 19:12:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2022-09-24 19:12:09 0 [Note] InnoDB: Starting shutdown...
2022-09-24 19:12:09 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-24 19:12:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-09-24 19:12:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-24 19:12:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-09-24 19:12:09 0 [ERROR] Aborting
 

有没有哪位小伙伴好的解决办法,在线求解~~~

[花花的小脑瓜]

@测试的小白 两个选一个就行

[花花的小脑瓜]

@测试的小白 1.找到my-small.ini文件，将my-small.ini另存为my.ini，在[mysqld]最后添加为上default-storage-engine=MyISAM，重启服务，数据库默认的引擎修改为MyISAM 2.建表时指定：create table mytbl( id int primary key, name varchar(50)) type=MyISAM;

[测试的小白]

@花花的小脑瓜 存储引擎怎么更换呢？

[花花的小脑瓜]

InnoDB' init function returned error. Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Unknown/unsupported storage engine: InnoDB从错误提示来看是选择的数据库存储引擎InnoDB不支持，换个就行

[惜分飞]

从这里看InnoDB: Header page consists of zero bytes in datafile: D:\Xampp\mysql\data\ibdata1, Space ID:0, Flags: 0
mysql ibdata文件异常了，这种情况下，就算初始化了ibdata，也无法恢复ibd或者以前的ibdata里面的数据，这种情况下，需要做mysql 非常规的恢复，你可以参考：
frm和ibd文件数据库恢复