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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby woodcycl » 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:

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.
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby Sharley » 12. October 2011 23:55

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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby woodcycl » 13. October 2011 00:08

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

Brian
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby woodcycl » 13. October 2011 00:43

###### 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?
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby Sharley » 13. October 2011 00:52

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby woodcycl » 13. October 2011 01:00

Sharley -- that worked. Many thanks to you! I am brand new to xampp, etc. and appreciate your help.
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: Not able to get into PHPMyAdmin?

Postby Sharley » 13. October 2011 01:02

Your welcome Brian and thanks for the feedback. 8)

Best wishes. ;)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests