Not able to access PHPMyAdmin (XP SP3) 1.7.7 [SOLVED}
Posted: 12. October 2011 23:39
I am using XAMPP for Wordpress development locally. I was having difficulty logging into wp-admin and went to phpMyAdmin and reset both ROOT user's passwords. Then, all of a sudden, I'm no longer able to get into phpMyAdmin. When I click on it, I get the following:
I've tried stopping and restarting MySQL in control panel v3 with no luck. Here's an excerpt from the MySQL error log, but I don't see anything other than the mentions of MySQL being shutdown improperly which occurs from usign the STOP button in the control panel.
Any help is appreciated.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I've tried stopping and restarting MySQL in control panel v3 with no luck. Here's an excerpt from the MySQL error log, but I don't see anything other than the mentions of MySQL being shutdown improperly which occurs from usign the STOP button in the control panel.
111012 18:35:36 [Note] Plugin 'FEDERATED' is disabled.
111012 18:35:36 InnoDB: The InnoDB memory heap is disabled
111012 18:35:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111012 18:35:36 InnoDB: Compressed tables use zlib 1.2.3
111012 18:35:36 InnoDB: Initializing buffer pool, size = 16.0M
111012 18:35:36 InnoDB: Completed initialization of buffer pool
111012 18:35:36 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111012 18:35:36 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 doublewrite
InnoDB: buffer...
111012 18:35:36 InnoDB: Waiting for the background threads to start
111012 18:35:37 InnoDB: 1.1.8 started; log sequence number 2903489
111012 18:35:37 [Note] Event Scheduler: Loaded 0 events
111012 18:35:37 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
Any help is appreciated.