且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

WAMP服务器保持脱机状态. MySQL服务未启动“无法启动wampmysqld64服务-错误1067".

更新时间:2021-12-18 23:19:29

在D:驱动器上安装WAMPServer很好.

Installing WAMPServer on the D: drive is just fine.

可能这些文件已损坏,因此请尝试将其删除.

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

停止WAMPServer

Stop WAMPServer

删除这些文件,因为这是初始安装,因此它们中将没有任何数据,并且WAMPServer的重启将导致MYSQL重新创建它们.

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

现在有一个小错误修复:编辑\wamp\bin\mysql\mysql5.6.17\my.ini 找到部分标记[wampmysqld]并将其更改为[wampmysqld64]

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]

保存my.ini

重新启动WAMPServer

Restart WAMPServer

此外,如果您的内存不足,则将此参数添加到[wampmysqld64]内的my.ini文件中将减少MYSQL内存需求.更高版本的MYSQL似乎使用了大量的内存(半个演出),其中很多是用于MYISAM文件的table_definition_cache,这会将其减少到合理的程度,并且不会影响您对MYISAM文件的使用.

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