WAMP 服务器保持离线状态。MySQL 服务未启动“无法启动 wampmysqld64 服务 - 错误 1067”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/32519474/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
WAMP Server stays offline. MySQL service not starting "could not start the wampmysqld64 service - error 1067"
提问by benscabbia
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:
第一次安装（Win 7 x64），光仍然是orage（服务器离线）。如果我查看服务，启动/恢复服务保持绿色：
If I go in services and try start wampmysqld64service I get this error message:
如果我进入服务并尝试启动wampmysqld64服务，我会收到以下错误消息：
Here is the Event Viewer Application log (the WAMP mysql log is empty):
这是事件查看器应用程序日志（WAMP mysql 日志为空）：
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 Ddrive (OS on C) due to space limitations).
我没有删除/删除任何文件，但由于空间限制，我确实在我的D驱动器上安装了 WAMP 服务器（OS on C）。
回答by RiggsFolly
Installing WAMPServer on the D: drive is just fine.
在 D: 驱动器上安装 WAMPServer 就好了。
Possibly somehow these files have been corrupted so try deleting them.
可能这些文件以某种方式被损坏，所以尝试删除它们。
Stop WAMPServer
停止 WAMP 服务器
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.
删除这些文件，因为这是初始安装，它们中没有任何数据，WAMPServer 的重新启动应该会导致 MYSQL 重新创建它们。
\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.iniFind the section marker [wampmysqld]and change it to [wampmysqld64]
现在进行一个小错误修复：编辑\wamp\bin\mysql\mysql5.6.17\my.ini查找部分标记[wampmysqld]并将其更改为[wampmysqld64]
Save my.ini
节省 my.ini
Restart WAMPServer
重启 WAMPServer
Also if you are a little short of memory adding this parameter to the my.inifile 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_cachefor MYISAM files, this will reduce it to something sensible and not effect your use of MYISAM files.
此外，如果您的内存有点不足，则将此参数添加到my.ini文件[wampmysqld64]中将减少 MYSQL 内存需求。MYSQL 的更高版本似乎使用了大量内存（半个 gig），其中很多是table_definition_cache用于 MYISAM 文件的，这会将其减少到合理的程度，并且不会影响您对 MYISAM 文件的使用。
[wampmysqld64]
table_definition_cache = 600
回答by marvatron
For me, I realised that I had another MySQL program (from Oracle) installed that was causing a common port-use conflict. Uninstall/disable MySQL server/workbench and other MySQL programs then restart WAMP. This might solve the problem, it worked for me.
对我来说，我意识到我安装了另一个 MySQL 程序（来自 Oracle），它导致了常见的端口使用冲突。卸载/禁用 MySQL 服务器/工作台和其他 MySQL 程序，然后重新启动 WAMP。这可能会解决问题，它对我有用。
I also uninstalled and deleted an old version of WAMP before installing the latest version.
在安装最新版本之前，我还卸载并删除了旧版本的 WAMP。
回答by Hideki Nakamura
In my case I just had to: edit \wamp\bin\mysql\mysql5.6.17\my.iniand find the section [wampmysqld]and change it to [wampmysqld64].
就我而言，我只需要：编辑\wamp\bin\mysql\mysql5.6.17\my.ini并找到该部分[wampmysqld]并将其更改为[wampmysqld64].
Then I restarted mysql and it worked!
然后我重新启动了 mysql 并且它起作用了！
回答by Saish Shinde
If mysql service is not starting open
my.inifile located atC:\wamp\bin\mysql\mysql[version]\my.iniChange port number to 3305 at 3 location:
如果 mysql 服务未启动，则
my.ini位于C:\wamp\bin\mysql\mysql[version]\my.ini在 3 个位置将端口号更改为 3305：
Here:
这里：
#password = your_password
port = 3305
socket = /tmp/mysql.sock
Here:
这里：
\# The MySQL server
[wampmysqld]
port = 3305
And here:
和这里：
[mysqld]
port=3305
- Now go to
C:\wamp\apps\phpmyadmin[version], findconfig.inc.phpand change this line:
- 现在转到
C:\wamp\apps\phpmyadmin[version]，找到config.inc.php并更改此行：
$cfg['Servers'][$i]['port'] = '3306';
to this:
对此：
$cfg['Servers'][$i]['port'] = '3305';
(3305 being the port you selected previously).
（3305 是您之前选择的端口）。
Those steps should get your MySQL running.
这些步骤应该让您的 MySQL 运行。
