diana Posted October 6, 2013 Share Posted October 6, 2013 i am using xampp for joomla project however i have encountered a problem that i have not been able to resolve although i tried hard..the problem is now i am not able to access my phpmyadmin..apache,mysql,mercury ,tomcat are all running normally without any problem but when i click on phpmyadmin i get the following error msg:MySQL said: Documentation#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)also when i checked the xampp status it displayed the following msgXAMPP StatusThis page offers you one page to view all information about what's running and working, and what isn't working.ComponentStatusHintMySQL database ACTIVATEDPHP ACTIVATEDHTTPS (SSL) ACTIVATEDCommon Gateway Interface (CGI) ACTIVATEDServer Side Includes (SSI) ACTIVATEDSMTP Service ACTIVATEDFTP Service DEACTIVATEDTomcat Service ACTIVATEDSome changes to the configuration may sometimes cause false negatives. All reports viewed with SSL (https://localhost) do not function!and the mysql_error log displays the following....131006 10:29:24 [Note] Plugin 'FEDERATED' is disabled.131006 10:29:25 InnoDB: The InnoDB memory heap is disabled131006 10:29:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions131006 10:29:25 InnoDB: Compressed tables use zlib 1.2.3131006 10:29:25 InnoDB: Initializing buffer pool, size = 16.0M131006 10:29:25 InnoDB: Completed initialization of buffer poolInnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:InnoDB: a new database to be created!131006 10:29:25 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...131006 10:29:26 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be createdInnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...131006 10:29:26 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be createdInnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: 127 rollback segment(s) active.InnoDB: Creating foreign key constraint system tablesInnoDB: Foreign key constraint system tables created131006 10:29:26 InnoDB: Waiting for the background threads to start131006 10:29:28 InnoDB: 5.5.32 started; log sequence number 0131006 10:29:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306131006 10:29:28 [Note] - '0.0.0.0' resolves to '0.0.0.0';131006 10:29:28 [Note] Server socket created on IP: '0.0.0.0'.131006 10:29:34 [Note] Event Scheduler: Loaded 0 events131006 10:29:34 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)131006 11:04:57 [Note] Plugin 'FEDERATED' is disabled.131006 11:04:57 InnoDB: The InnoDB memory heap is disabled131006 11:04:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions131006 11:04:57 InnoDB: Compressed tables use zlib 1.2.3131006 11:04:57 InnoDB: Initializing buffer pool, size = 16.0M131006 11:04:57 InnoDB: Completed initialization of buffer pool131006 11:04:57 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!131006 11:04:57 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...131006 11:04:57 InnoDB: Waiting for the background threads to start131006 11:04:58 InnoDB: 5.5.32 started; log sequence number 1595675131006 11:04:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306131006 11:04:58 [Note] - '0.0.0.0' resolves to '0.0.0.0';131006 11:04:58 [Note] Server socket created on IP: '0.0.0.0'.131006 11:04:58 [Note] Event Scheduler: Loaded 0 events131006 11:04:58 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)131006 11:20:52 [Note] Plugin 'FEDERATED' is disabled.131006 11:20:52 InnoDB: The InnoDB memory heap is disabled131006 11:20:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions131006 11:20:52 InnoDB: Compressed tables use zlib 1.2.3131006 11:20:52 InnoDB: Initializing buffer pool, size = 16.0M131006 11:20:52 InnoDB: Completed initialization of buffer pool131006 11:20:52 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!131006 11:20:52 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...131006 11:20:52 InnoDB: Waiting for the background threads to start131006 11:20:53 InnoDB: 5.5.32 started; log sequence number 1595675131006 11:20:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306131006 11:20:54 [Note] - '0.0.0.0' resolves to '0.0.0.0';131006 11:20:54 [Note] Server socket created on IP: '0.0.0.0'.131006 11:20:54 [Note] Event Scheduler: Loaded 0 events131006 11:20:54 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)131006 11:41:32 [Note] Plugin 'FEDERATED' is disabled.131006 11:41:32 InnoDB: The InnoDB memory heap is disabled131006 11:41:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions131006 11:41:32 InnoDB: Compressed tables use zlib 1.2.3131006 11:41:32 InnoDB: Initializing buffer pool, size = 16.0M131006 11:41:32 InnoDB: Completed initialization of buffer pool131006 11:41:32 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!131006 11:41:32 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...131006 11:41:32 InnoDB: Waiting for the background threads to start131006 11:41:33 InnoDB: 5.5.32 started; log sequence number 1595675131006 11:41:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306131006 11:41:33 [Note] - '0.0.0.0' resolves to '0.0.0.0';131006 11:41:33 [Note] Server socket created on IP: '0.0.0.0'.131006 11:41:33 [Note] Event Scheduler: Loaded 0 events131006 11:41:33 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.Version: '5.5.32' socket: '' port: 3306 MySQL Community Server (GPL)i am struggling with this problem since last three days and still not able to solve it..it is causing a hindrance in the progress of my project..i also like to inform that after this problem i took a backup of my project and then i unistalled and installed the xampp saveral times still i am not able to solve it.. also i was using wamp earlier when this problem started i thought that such problem may not occur in xampp...i had my joomla wordpress and yii framework used to carry my projects..not able to get acces to my project and work on it since last few days is frustrating me...please guide methanks.. Link to comment Share on other sites More sharing options...
Larry Posted October 7, 2013 Share Posted October 7, 2013 It sounds like you need to change phpMyAdmin's configuration to connect to MySQL. Specifically, the port is probably wrong. You'll need to first find out what port MySQL is using and then change phpMyAdmin's configuration. Link to comment Share on other sites More sharing options...
Recommended Posts