php wamp 服务器错误 #2002 无法打开 phpMyAdmin

error with wamp server error #2002 could not open phpMyAdmin

提问by LebDev

i have installed the wamp serverand i was work perfectly but now i try to open the phpMyAdminbut the server display this error

我已经安装了wamp 服务器，并且运行良好，但现在我尝试打开phpMyAdmin，但服务器显示此错误

**Error MySQL said: Documentation

**错误 MySQL 说：文档

2002 - No connection could be made because the target machine actively refused it.

2002 - 无法建立连接，因为目标机器主动拒绝它。

The server is not responding (or the local server's socket is not correctly configured).** can anyone help me ????

服务器没有响应（或本地服务器的套接字未正确配置）。** 谁能帮我？？？？

mysql.log

mysql.log

130816 10:30:30 [Note] Plugin 'FEDERATED' is disabled.
130816 10:30:30 InnoDB: The InnoDB memory heap is disabled
130816 10:30:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130816 10:30:30 InnoDB: Compressed tables use zlib 1.2.3
130816 10:30:30 InnoDB: Initializing buffer pool, size = 128.0M
130816 10:30:30 InnoDB: Completed initialization of buffer pool
130816 10:30:30 InnoDB: highest supported file format is Barracuda.
130816 10:30:32  InnoDB: Waiting for the background threads to start
130816 10:30:33 InnoDB: 1.1.8 started; log sequence number 6780464
130816 10:30:34 [Note] Server hostname (bind-address): '(null)'; port: 3306
130816 10:30:34 [Note]   - '(null)' resolves to '::';
130816 10:30:34 [Note]   - '(null)' resolves to '0.0.0.0';
130816 10:30:34 [Note] Server socket created on IP: '0.0.0.0'.
130816 10:30:35 [Note] Event Scheduler: Loaded 0 events
130816 10:30:35 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
130816 10:31:48 [Note] wampmysqld: Normal shutdown

130816 10:31:48 [Note] Event Scheduler: Purging the queue. 0 events
130816 10:31:48  InnoDB: Starting shutdown...
130816 10:31:50  InnoDB: Shutdown completed; log sequence number 6780474
130816 10:31:50 [Note] wampmysqld: Shutdown complete

130816 10:31:51 [Note] Plugin 'FEDERATED' is disabled.
130816 10:31:51 InnoDB: The InnoDB memory heap is disabled
130816 10:31:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130816 10:31:51 InnoDB: Compressed tables use zlib 1.2.3
130816 10:31:51 InnoDB: Initializing buffer pool, size = 128.0M
130816 10:31:51 InnoDB: Completed initialization of buffer pool
130816 10:31:51 InnoDB: highest supported file format is Barracuda.
130816 10:31:52  InnoDB: Waiting for the background threads to start
130816 10:31:53 InnoDB: 1.1.8 started; log sequence number 6780474
130816 10:31:53 [Note] Server hostname (bind-address): '(null)'; port: 3306
130816 10:31:53 [Note]   - '(null)' resolves to '::';
130816 10:31:53 [Note]   - '(null)' resolves to '0.0.0.0';
130816 10:31:53 [Note] Server socket created on IP: '0.0.0.0'.
130816 10:31:53 [Note] Event Scheduler: Loaded 0 events
130816 10:31:53 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

采纳答案by Vineet1982

All you need to do is to click on the WAMP server icon in the system tray and go to mySQL and my.ini. Open the file in a text editor like notepad. At the top of the page there should be a line

您需要做的就是单击系统托盘中的 WAMP 服务器图标，然后转到 mySQL 和 my.ini。在记事本等文本编辑器中打开文件。在页面顶部应该有一行

socket = /tmp/mysql.sock

change that to

将其更改为

socket = c:/tmp/mysql.sock

Save the file and try running phpmyAdmin. Restart wamp. It should work perfectly.

保存文件并尝试运行 phpmyAdmin。重启wamp。它应该可以完美运行。

If this does not fix the error for you let me know and I will try and help.

如果这不能解决您的错误，请告诉我，我会尽力提供帮助。

回答by guil

All you need to do is to

您需要做的就是

• First exit your wampserver
• Then go to "C:\wamp\bin\mysql\mysql5.6.17\data"
• Note: don't delete the folders, it is important then after that delete all the files except for the folders
• After that don't close "C:\wamp\bin\mysql\mysql5.6.17\data"
• Now open again the wampserver and wait until the wampserver tray turn to green

• 首先退出你的 wampserver
• 然后转到“C:\wamp\bin\mysql\mysql5.6.17\data”
• 注意：不要删除文件夹，重要的是之后删除除文件夹之外的所有文件
• 之后不要关闭“C:\wamp\bin\mysql\mysql5.6.17\data”
• 现在再次打开 wampserver 并等待 wampserver 托盘变为绿色

and that's it!

就是这样！

回答by Miril Terolli

Well, I had the same issue, I searched on google for any better solution but i found nothing helpful. So, what I did, is: Unistall Wamp, delete the wamp folder from C and reinstalled wamp again. I KNOW is not the best solution but it's still the one that worked for me.

好吧，我遇到了同样的问题，我在谷歌上搜索了任何更好的解决方案，但我发现没有任何帮助。所以，我所做的是：卸载 Wamp，从 C 中删除 wamp 文件夹并重新安装 wamp。我知道不是最好的解决方案，但它仍然对我有用。

回答by Fr4nz

I had this problem when wampmysqldservice was blocked in stoppingstate. If you happen to have the same problem again you can try the following :

当wampmysqld服务处于阻塞stopping状态时，我遇到了这个问题。如果您碰巧再次遇到同样的问题，您可以尝试以下操作：

1. Shut down wamp server
2. Click Start.
3. In the Start Search box, type cmd, and then press CTRL+SHIFT+ENTER. (Run console as Administrator)
4. Type Taskkill /F /FI "SERVICES eq wampmysqldand then ENTER.
5. If everything works as expected you will see SUCCESS: The process with PID XXXX has been terminated.
6. Restart wamp server, the icon should be green again.

1. 关闭 wamp 服务器
2. 单击开始。
3. 在“开始搜索”框中，键入cmd，然后按CTRL+ SHIFT+ ENTER。（以管理员身份运行控制台）
4. 键入Taskkill /F /FI "SERVICES eq wampmysqld然后ENTER。
5. 如果一切正常，你会看到 SUCCESS: The process with PID XXXX has been terminated.
6. 重新启动 wamp 服务器，图标应该再次变为绿色。

This did the trick for me.

这对我有用。

回答by zozothemes

Simple is remove service from service section of mysql tab. And install service again. Now all working fine. Your wamp turns into green.

简单的是从 mysql 选项卡的服务部分删除服务。并再次安装服务。现在一切正常。你的 wamp 变成了绿色。

Thanks, zozothemes

谢谢，zozothemes

回答by Fredrick Joseph

Alright ,I tried few solutions and they didn't work, Then i realized i should restart WAMP server. So i tried to start wamp server's tray and STOPPED ALL SERVICES AND STARTED ALL THE SERVICES, .... Try that, it worked for me,Have a wonderful day :)

好吧，我尝试了一些解决方案，但它们不起作用，然后我意识到我应该重新启动 WAMP 服务器。所以我尝试启动 wamp 服务器的托盘并停止所有服务并启动所有服务，....试试看，它对我有用，祝你有美好的一天:)

回答by Roy

It is the wampmysql service which makes the icon green. If nothing works, must check your services by going to control panel>services and search for this service. Once found, check whether it has been started or disabled. Start it and there you go :)

使图标变绿的是 wampmysql 服务。如果没有任何效果，必须通过转到控制面板>服务并搜索此服务来检查您的服务。找到后，检查它是否已启动或禁用。启动它，然后你去:)