Apache Friends Support Forum

I am running XAMPP on my desktop computer with Windows XP 2 . Everything worked fine till yesterday. And now I forgot password for phpmyadmin root user . So I could not able to login to it or manage other content .

I could not even change it as I don't remember the current password( I have tried here http://localhost/security/xamppsecurity.php . But it asks current password) . And I can't find any password files in D:\xampp\security though

Could any one tell me where and how to recover the password ?

Thanks !

The root user password is the same for MySQL and phpMyAdmin.

You will need to reset the password as it can't be recovered.

Follow the following instructions.

The file C:\xampp\mysql\resetroot.bat file is used to do this chore - pays to make a note somewhere of the password to prevent having to do this each time the password is forgotten.

To use the resetroot.bat file you would need to edit the file to be able to use it in a Windows environment - currently written to use in a *nix environment and so will not do anything except produce an error message.

These posts have some of the details required to edit the resetroot.bat file:
viewtopic.php?p=181829#p181829
viewtopic.php?p=167128#p167128
viewtopic.php?p=130759#p130759
http://bravo.newnetenterprises.com/word ... -password/

There is also a detailed alternative method to be found on the MySQL Development site here:
http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html