error with wamp server error #2002 could not open phpMyAdmin
error-handling, mysql, php, wampserver
Solution
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.
Problem
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) ```