Not able to access PHPMyAdmin (XP SP3) 1.7.7 [SOLVED}

[woodcycl]

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:

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.

[Sharley]

We require your XAMPP version and your Windows Version to provide the correct version support - please read the following Announcements.
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Thanks.

Depending on your XAMPP version try the following but please remember to always include the above referenced information as there are now XAMPP versions that are quite different in how we offer advices.


In \xampp\mysql there is a bat file resetroot.bat that wil reset the root user back to having no password.

Try and login to phpMyAdmin using http://localhost/phpmyadmin useing root no password.

If successful then you only change the root password in the XAMPP Welcome page (often referred to as the XAMPP Admin page) under the Security menu item,

BTW - you should not use super user root to access the WP database but rather create a specific user/pass combo for WP or any database you create.

Only use super user root for admin access to MySQL and phpMyAdmin.

Good luck.

[woodcycl]

Thank you Sharley - I will give it a try. Much appreciated.

Brian

[woodcycl]

###### ApacheFriends XAMPP version 1.7.7 ######
+ Apache 2.2.21
+ MySQL 5.5.16 (Community Server)
+ PHP 5.3.8 (VC9 X86 32bit thread safe) + PEAR
WinXP Pro SP3

I successfully ran resetroot.bat. However, when I click on phpMyAdmin in xampp (http://localhost), I continue to receive the error mentioned in the OP. Any thoughts?

[Sharley]

Open \xampp\mysql\bin\my.ini and uncomment this line so it looks like this

Code: Select all

bind-address = "127.0.0.1"

Open \xampp\phpmyadmin\config.inc.php and check that this section looks like this

Code: Select all

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Save both files after editing and restart MySQL then try phpMyAdmin again.

[woodcycl]

Sharley -- that worked. Many thanks to you! I am brand new to xampp, etc. and appreciate your help.

[Sharley]

Your welcome Brian and thanks for the feedback.

Best wishes.