Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

error with wamp server error #2002 could not open phpMyAdmin [duplicate]

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)
like image 486
LebDev Avatar asked Mar 23 '23 18:03

LebDev


1 Answers

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!

like image 57
guil Avatar answered Apr 06 '23 18:04

guil