Lost password for phpMyAdmin

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

Lost password for phpMyAdmin

Postby gandalf458 » 05. June 2011 09:11

I have Xampp 1.7.3 on my Windows 7 test machine. I have not been in to phpMyAdmin for some while and have forgotten the password. Is there some way to reset or recover it?

My config.inc.php file includes:
Code: Select all
$cfg['Servers'][$i]['auth_type']            = 'cookie';
$cfg['Servers'][$i]['user']                 = 'root';
$cfg['Servers'][$i]['password']             = '';
$cfg['Servers'][$i]['AllowNoPassword']      = true;

but I can't get in using root and no password.
Blessed are the cracked for they let in the light
gandalf458
 
Posts: 11
Joined: 01. April 2008 19:41

Re: Lost password for phpMyAdmin

Postby Sharley » 05. June 2011 09:42

With MySQL running go to \xampp\mysql folder and run the resetroot.bat file (right click on the file and select to run as an administrator if you have problems), which should fix your issue and allow access without a password until you set one again using the Security page in the XAMPP Welcome Page.
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: Lost password for phpMyAdmin

Postby gandalf458 » 05. June 2011 10:10

Thanks. Tried it but got:
Can't create test file \usr\local\mysql\data\MyPC.lower-test and several other messages - seems to be looking for a Unix file system!!
Blessed are the cracked for they let in the light
gandalf458
 
Posts: 11
Joined: 01. April 2008 19:41

Re: Lost password for phpMyAdmin

Postby Sharley » 05. June 2011 10:14

Take your pick from this:
http://bravo.newnetenterprises.com/word ... -password/

Or this:
viewtopic.php?p=167128#p167128

Or do it using the command line from this MySQL site instruction:
http://dev.mysql.com/doc/refman/5.0/en/ ... ns-windows
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: Lost password for phpMyAdmin

Postby gandalf458 » 05. June 2011 10:44

Ha - thanks. Even without the bug I should have thought to stop the MySQL server!

Cheers G:)
Blessed are the cracked for they let in the light
gandalf458
 
Posts: 11
Joined: 01. April 2008 19:41


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 72 guests