Apache Friends Support Forum

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.

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.

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!!

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

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

Cheers G:)