MySQL Wamp 服务器图标为红色
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10736487/
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 icon is red
提问by user501582
I recently installed wamp server 2.2 in my system. But the icon is red for some weird reason. I am able to see phpmyadmin but when I open MySQL(http://localhost/phpmyadmin) it says
我最近在我的系统中安装了 wamp server 2.2。但是由于某种奇怪的原因，该图标是红色的。我可以看到 phpmyadmin，但是当我打开 MySQL(http://localhost/phpmyadmin) 时，它说
MySQL said:
MySQL 说：
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
#2002 - 服务器没有响应（或者本地 MySQL 服务器的套接字没有正确配置）
I checked the task manager and I can only see wampmanager.exe running. I tested port 80 and it says
我检查了任务管理器，只能看到 wampmanager.exe 正在运行。我测试了端口 80，它说
Your port 80 is actually used by: server: Apache/2.2.17(Wind32) PHP/5.3.5
你的 80 端口实际上被使用： server: Apache/2.2.17(Wind32) PHP/5.3.5
Also in Apache>Service start/resume service, stop service, restart service are disabled.
同样在 Apache>Service 中启动/恢复服务，停止服务，重启服务被禁用。
Please tell me what is the issue.
请告诉我是什么问题。
回答by rkaartikeyan
Click WampServer Icon.
单击 WampServer 图标。
- Apache > Service > Install Service
- Apache > Service > Start/Resume Service
- MySQL > Service > Install Service
- MySQL > Service > Start/Resume Service
- Apache > 服务 > 安装服务
- Apache > 服务 > 启动/恢复服务
- MySQL > 服务 > 安装服务
- MySQL > 服务 > 启动/恢复服务
回答by Vini
Solution that worked for me:
对我有用的解决方案：
- Access services.msc (Control Panel -> Administrative Tools -> Services);
- Find all the services that start with
"wamp". In my case:wampapache64andwampmysqld64; - Double click on each of them and set the start-up type as:
"automatic"; - Restart all services of wamp, by clicking once on its tray icon and selecting the option
"Restart All Services".
- 访问 services.msc（控制面板 -> 管理工具 -> 服务）；
- 查找所有以
"wamp". 就我而言：wampapache64和wampmysqld64; - 双击每一个并将启动类型设置为：
"automatic"; - 通过在其托盘图标上单击一次并选择选项，重新启动 wamp 的所有服务
"Restart All Services"。
I don't know why, but, somehow, the services start-up types where marked as "Disabled". Maybe some other software made it without my consent. Because of that, the Wampwas with a red icon, but showing onlinewhen hoovering the mouse over it.
我不知道为什么，但不知何故，服务启动类型标记为"Disabled". 也许其他一些软件未经我同意就制作了它。因此，Wamp带有一个红色图标，但将鼠标悬停在它上面时会显示在线。
回答by Sai Chaithanya
Well I tried them all but dint work. After few trials the following worked for me.
好吧，我尝试了所有方法，但效果不佳。经过几次试验后，以下对我有用。
Start task manager open 'Services'tab and click "Services.." at the bottom. A Services window shows up.
启动任务管理器打开“服务”选项卡，然后单击底部的“服务..”。服务窗口出现。
Now search for wampmysqldand double click on it. Just make startup type as automatic and start the service by clicking start at Service status section down there. You can see you wamp icon yellow.
现在搜索wampmysqld并双击它。只需将启动类型设为自动，然后通过单击下方“服务状态”部分的“启动”来启动服务。你可以看到你的 wamp 图标是黄色的。
Go back to the services window and do same for wampapache. Double click on it. Just make startup type as automatic and start the service by clicking start at Service status section down there. Wamp icon turns in to green and now localhost can be used.
返回服务窗口并对wampapache执行相同操作。双击它。只需将启动类型设为自动，然后通过单击下方“服务状态”部分的“启动”来启动服务。Wamp 图标变为绿色，现在可以使用 localhost。
回答by ePeace
Some other programs conflict with wampserver, I don't know them all by heart, but I know when skype is running wampserver can't go online.
其他一些程序和wampserver有冲突，我不是很熟，但是我知道skype运行的时候wampserver不能上网。
回答by Mayank Agarwal
Try installing WAMP 2.1 I also tried each and everything, but install WAMP 2.1, refrain from 2.2,
尝试安装 WAMP 2.1 我也尝试过每一个，但安装 WAMP 2.1，不要安装 2.2，
http://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.1/
http://sourceforge.net/projects/wampserver/files/WampServer%202/WampServer%202.1/
Some of the posts i read also suggest installing WAMP 2.1 !
我读过的一些帖子还建议安装 WAMP 2.1！
Have a gr8 time!
有一个gr8时间！
回答by Amit Panchal
you have to star all the three services automatic then you get the green color of the wamp server symbol that means all thee three services running sucessfully.
您必须自动为所有三个服务加星标，然后您会看到 wamp 服务器符号的绿色，这意味着所有三个服务都成功运行。
回答by Dhruv
回答by fat_mike
Check MySQL log file Click wamp icon>MySQL MySQL log. Check the last lines of the file. If you see:
检查 MySQL 日志文件 单击 wamp 图标>MySQL MySQL 日志。检查文件的最后几行。如果你看到：
[ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
[ERROR] Do you already have another mysqld server running on port: 3306 ?
[ERROR] Aborting
[错误] 无法启动服务器：在 TCP/IP 端口上绑定：没有这样的文件或目录
[错误] 你是否已经有另一个 mysqld 服务器在端口上运行：3306？
[错误] 正在中止
Open Administrative tools of windows go to services search and stop MySQL service. Then restart all services of wamp.
打开windows的管理工具去服务搜索并停止MySQL服务。然后重启wamp的所有服务。
Also a lot of applications (more common skype) use 80 port to communicate. So you might have to change the port of your localhost.
还有很多应用程序（更常见的Skype）使用80端口进行通信。因此，您可能需要更改本地主机的端口。
Oh and dont forget to clear your browser cache. This might help as well.
哦，不要忘记清除浏览器缓存。这也可能有帮助。
回答by WebArtisan
If that will help someone: Run from "Services" wampapache64 and wampmysql64 manually. Then run wamp.
如果这对某人有帮助：手动从“服务” wampapache64 和 wampmysql64 运行。然后运行 wamp。
Perhaps you remove this services from autoload in msconfig.
也许您从 msconfig 中的自动加载中删除了此服务。
That works for me.
这对我行得通。
回答by user3402248
The issue might be because SQL Server process are running in the background. Goto Control Panel and Click on Adminstrative Tools and then goto Services. Disable all the services that start with SQL Server. Restart the server, it should turn Orange now. Check whether the Start/Resume Service in Apache->Service is green or not. In case it's not green it means that the Apache server is running normally. So now the issue is with MYSQL. Again goto Control Panel->Adminstrative tools->Services, Disable the MYSQL 56 process. Restart the Server. It should turn green now.
问题可能是因为 SQL Server 进程在后台运行。转到控制面板并单击管理工具，然后转到服务。禁用所有以 SQL Server 开头的服务。重新启动服务器，它现在应该变成橙色。检查Apache->Service 中的Start/Resume Service 是否为绿色。如果它不是绿色，则表示 Apache 服务器运行正常。所以现在问题出在 MYSQL 上。再次转到控制面板-> 管理工具-> 服务，禁用 MYSQL 56 进程。重新启动服务器。它现在应该变成绿色。
I have written a blog which further explains the problem and might help you resolve it.Solving the WAMP Issue
我写了一篇博客，进一步解释了这个问题，可能会帮助你解决它。解决 WAMP 问题
