Reset Your Magento Admin Password
I lost my Magento admin password and the server was not configured to send email so I was stuck in a bind. Of course I turned to Professor Google for help. Most of the instructions would not work for me since I cannot send mail from my server and I am not a MD5 Hash expert. Then I found this little nugget of wisdom in a Magento Forum:
UPDATE admin_user SET password=CONCAT(MD5(‘qXpassword’), ‘:qX’) WHERE username=’admin’;
Fire up PHPmyAdmin and run this SQL command changing password to whatever you wish, change admin to your username. The qX can also be change to whatever you wish. Done. Problem solved.