问题描述:

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

**Error

MySQL said: Documentation

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

The server is not responding (or the local server's socket is not correctly configured).**

can anyone help me ????

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)

网友答案:

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

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.

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

网友答案:

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

and that's it!

网友答案:

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.

网友答案:

I had this problem when wampmysqld service was blocked in stopping state. If you happen to have the same problem again you can try the following :

  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 wampmysqld and 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.

This did the trick for me.

网友答案:

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

Thanks, zozothemes

相关阅读:
Top