blocks|key|1320216|text|在D:驱动器上安装WAMPServer很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320217|这些文件可能已经损坏，所以请尝试删除它们。|1320218|停止WAMPServer|1320219|删除这些文件，因为这是一个初始安装，它们中没有任何数据，重新启动WAMPServer应该会导致MYSQL重新创建它们。|1320220|\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|code-block|syntax|javascript|1320221|现在，对于一个小bug修复:编辑\wamp\bin\mysql\mysql5.6.17\my.ini，找到节标记[wampmysqld]并将其更改为[wampmysqld64]|offset|length|style|CODE|1320222|保存my.ini|1320223|重启WAMPServer|1320224|另外，如果内存不足，将此参数添加到my.ini文件中，[wampmysqld64]将减少对MYSQL内存的需求。MYSQL的后期版本似乎使用了大量内存(半个gig+)--其中很多是MYISAM文件的table_definition_cache，这将使它变得合理，而不会影响您对MYISAM文件的使用。|1320225|[wampmysqld64]
table_definition_cache+=+600|1320226|entityMap^0|0|0|0|0|0|G|Y|1K|C|22|E|0|2|6|0|0|H|6|R|E|2R|M|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|16|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|17|8|@$O|18|P|19|Q|R]|$O|1A|P|1B|Q|R]|$O|1C|P|1D|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1E|8|@$O|1F|P|1G|Q|R]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1I|8|@$O|1J|P|1K|Q|R]|$O|1L|P|1M|Q|R]|$O|1N|P|1O|Q|R]]|9|@]|A|$]]|$1|Y|3|Z|5|J|7|1P|8|@]|9|@]|A|$K|L]]|$1|10|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|11|$]]

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.

<pre><code>\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
</code></pre>

Now for a little bug fix: Edit <code>\wamp\bin\mysql\mysql5.6.17\my.ini</code>
Find the section marker <code>[wampmysqld]</code> and change it to <code>[wampmysqld64]</code>

Save <code>my.ini</code>

Restart WAMPServer

Also if you are a little short of memory adding this parameter to the <code>my.ini</code> file inside the <code>[wampmysqld64]</code> 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 <code>table_definition_cache</code> for MYISAM files, this will reduce it to something sensible and not effect your use of MYISAM files.

<pre><code>[wampmysqld64]
table_definition_cache = 600
</code></pre>

blocks|key|1320235|text|在我的例子中，我只需:编辑\wamp\bin\mysql\mysql5.6.17\my.ini并找到[wampmysqld]部分并将其更改为[wampmysqld64]。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1320236|然后我重新启动mysql，它成功了！|1320237|entityMap^0|D|Y|1E|C|1Y|E|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

In my case I just had to: edit <code>\wamp\bin\mysql\mysql5.6.17\my.ini</code> and find the section <code>[wampmysqld]</code> and change it to <code>[wampmysqld64]</code>.

Then I restarted mysql and it worked!

blocks|key|1320248|text|如果mysql服务没有启动，则打开位于C:\wamp\bin\mysql\mysql[version]\my.ini的C:\wamp\bin\mysql\mysql[version]\my.ini文件。|type|ordered-list-item|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1320249|在3个位置将端口号更改为3305：|1320250|在此：|unstyled|1320251|#password+++=+your_password
port++++++++=+3305
socket++++++=+/tmp/mysql.sock|code-block|syntax|javascript|1320252|1320253|\#+The+MySQL+server
[wampmysqld]
port++++++++=+3305|1320254|在这里：|1320255|[mysqld]
port=3305|1320256|现在转到C:\wamp\apps\phpmyadmin[version]，找到config.inc.php并更改这一行：|1320257|$cfg['Servers'][$i]['port']+=+'3306';|1320258|对此：|1320259|$cfg['Servers'][$i]['port']+=+'3305';|1320260|(3305是您先前选择的端口)。|1320261|这些步骤将使您的MySQL运行。|1320262|entityMap^0|J|13|1N|13|0|0|0|0|0|0|0|0|4|W|13|E|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1F|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1G|8|@]|D|@]|E|$]]|$1|K|3|L|5|M|7|1H|8|@]|D|@]|E|$N|O]]|$1|P|3|I|5|J|7|1I|8|@]|D|@]|E|$]]|$1|Q|3|R|5|M|7|1J|8|@]|D|@]|E|$N|O]]|$1|S|3|T|5|J|7|1K|8|@]|D|@]|E|$]]|$1|U|3|V|5|M|7|1L|8|@]|D|@]|E|$N|O]]|$1|W|3|X|5|6|7|1M|8|@$9|1N|A|1O|B|C]|$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|M|7|1R|8|@]|D|@]|E|$N|O]]|$1|10|3|11|5|J|7|1S|8|@]|D|@]|E|$]]|$1|12|3|13|5|M|7|1T|8|@]|D|@]|E|$N|O]]|$1|14|3|15|5|J|7|1U|8|@]|D|@]|E|$]]|$1|16|3|17|5|J|7|1V|8|@]|D|@]|E|$]]|$1|18|3|-4|5|J|7|1W|8|@]|D|@]|E|$]]]|19|$]]

<ol>
<li>If mysql service is not starting open <code>my.ini</code> file located at <code>C:\wamp\bin\mysql\mysql[version]\my.ini</code></li>
<li>Change port number to 3305 at 3 location:</li>
</ol>

Here:

<pre class="lang-none prettyprint-override"><code>#password = your_password
port = 3305
socket = /tmp/mysql.sock
</code></pre>

Here:

<pre class="lang-none prettyprint-override"><code>\# The MySQL server
[wampmysqld]
port = 3305
</code></pre>

And here:

<pre class="lang-none prettyprint-override"><code>[mysqld]
port=3305
</code></pre>

<ol start="3">
<li>Now go to <code>C:\wamp\apps\phpmyadmin[version]</code>, find <code>config.inc.php</code> and change this line:</li>
</ol>

<pre class="lang-none prettyprint-override"><code>$cfg['Servers'][$i]['port'] = '3306';
</code></pre>

to this:

<pre class="lang-none prettyprint-override"><code>$cfg['Servers'][$i]['port'] = '3305';
</code></pre>

(3305 being the port you selected previously).

Those steps should get your MySQL running.

blocks|key|851539|text|对我来说，我意识到我安装了另一个MySQL程序(来自甲骨文)，这导致了一个常见的端口使用冲突。卸载/禁用MySQL服务器/工作台和其他MySQL程序，然后重新启动WAMP。这也许能解决这个问题，对我来说很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|851540|在安装最新版本之前，我还卸载并删除了一个旧版本的WAMP。|851541|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

I also uninstalled and deleted an old version of WAMP before installing the latest version.

blocks|key|617466|text|WAMP是一个不太稳定的平台。我建议使用XAMPP而不是WAMP。与WAMP服务器相比，它很轻，而且比WAMP更稳定.|type|unstyled|depth|inlineStyleRanges|entityRanges|data|617467|福利-|617468|XAMPP比WAMP具有更强大的功能和更多的资源占用。WAMP提供了对MySQL和PHP的支持。XAMPP提供对MYSQL、PHP和PERL的支持|617469|XAMPP也有SSL功能，而WAMP没有。如果您的应用程序只需要处理本地web应用程序，请选择WAMP。如果您需要上面提到的高级特性，可以选择XAMPP。|617470|由于XAMPP获得了更高的优先级并占用了端口，因此不能同时运行默认安装。因此，WAMP不能与XAMPP并行运行。|617471|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

WAMP is a less stable platform. I would suggest XAMPP over WAMP.
It is light compared to wamp-server and much stable than WAMP.
Benefits -
XAMPP is more powerful and resource taking than WAMP.
WAMP provides support for MySQL and PHP.
XAMPP provides support for MYSQL, PHP and PERL
XAMPP also has SSL feature while WAMP doesn't.
If your applications need to deal with native web apps only, Go for WAMP. If you need advanced features as stated above, go for XAMPP.
As of priority, you cant run both together with default installation as XAMPP gets a higher priority and it takes up ports. So WAMP can't be run in parallel with XAMPP.

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: 

<a href="https://i.stack.imgur.com/d3zqH.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/d3zqH.jpg" alt="enter image description here"></a>

If I go in services and try start <code>wampmysqld64</code> service I get this error message: 

<a href="https://i.stack.imgur.com/tchwQ.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/tchwQ.jpg" alt="enter image description here"></a>

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

<pre><code>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
</code></pre>

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

WAMP Server stays offline. MySQL service not starting "could not start the wampmysqld64 service - error 1067"

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我花了几个小时试图让服务器运行(这是第一次)，尝试了许多在线发布的解决方案，但都没有成功。第一次安装(Win 7 x64)时，光线保持正常(服务器离线)。如果我查看服务，开始/恢复服务仍然是绿色的：​​如果我进入服务并尝试启动wampmysqld64服务，就会得到以下错误消息：​​下面是事件查看器应用程序日志( WAM...

问WAMP Server保持脱机。未启动的MySQL服务“无法启动wampmysqld64服务-错误1067”
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问WAMP Server保持脱机。未启动的MySQL服务“无法启动wampmysqld64服务-错误1067”EN