WAMP服务器无法启动MySQL服务，错误1067-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_39527487/article/details/113227523

在初次安装WAMP64服务器时遇到服务无法启动的问题，表现为MySQL服务启动时提示错误1067。错误日志显示InnoDB存储引擎无法注册。解决方案包括删除可能损坏的MySQL数据文件，编辑my.ini将[wampmysqld]改为[wampmysqld64]，以及在my.ini中调整table_definition_cache以减少内存需求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I have spent hours trying to get the server running (for the first time), trying many solutions posted online, but to no success.

First time install (Win 7 x64), light remains orage (server offline). If I look at service, the start/resume service remains green:

If I go in services and try start wampmysqld64 service I get this error message:

Here is the Event Viewer Application log (the WAMP mysql log is empty):

Error 11/09/2015 09:04:22 MySQL 100 None Aborting

Error 11/09/2015 09:04:22 MySQL 100 None Unknown/unsupported storage engine: InnoDB

Error 11/09/2015 09:04:22 MySQL 100 None Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Error 11/09/2015 09:04:22 MySQL 100 None Plugin 'InnoDB' init function returned error.

Error 11/09/2015 09:04:22 MySQL 100 None 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!

Error 11/09/2015 09:04:22 MySQL 100 None InnoDB: space header page consists of zero bytes in data file .\ibdata1

Warning 11/09/2015 09:04:22 MySQL 100 None InnoDB: Doublewrite does not have page_no=0 of space: 0

I haven't removed/deleted any files, but I did install WAMP server on my D drive (OS on C) due to space limitations).

解决方案

Installing WAMPServer on the D: drive is just fine.

Possibly somehow these files have been corrupted so try deleting them.

Stop WAMPServer

Delete these files, as this is an initial install they will not have any data in them and the restart of WAMPServer should cause MYSQL to re-create them.

\wamp\bin\mysql\mysql5.6.17\data\ib_logfile0

\wamp\bin\mysql\mysql5.6.17\data\ib_logfile1

\wamp\bin\mysql\mysql5.6.17\data\ibdata1

Now for a little bug fix: Edit \wamp\bin\mysql\mysql5.6.17\my.ini

Find the section marker [wampmysqld] and change it to [wampmysqld64]

Save my.ini

Restart WAMPServer

Also if you are a little short of memory adding this parameter to the my.ini file inside the [wampmysqld64] will reduce the MYSQL memory requirement. Later versions of MYSQL seem to use a hugh amounts of memory ( half a gig ) lots of which is the table_definition_cache for MYISAM files, this will reduce it to something sensible and not effect your use of MYISAM files.

[wampmysqld64]

table_definition_cache = 600