Unable to recover password for phpmyadmin

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

Unable to recover password for phpmyadmin

Postby vnu » 11. August 2011 15:27

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 !
Posts: 4
Joined: 11. August 2011 15:17

Re: Unable to recover password for phpmyadmin

Postby Sharley » 12. August 2011 03:59

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:
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
User avatar
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: DoughyInTheMiddle and 67 guests