Magento Admin Password Reset Through DataBase

Published on December 12, 2012

If you developer and you using magento in localhost there may chance that some times you may forget the admin password in such situations just use the following code in your phpmyadmin SQL Query window

UPDATE `admin_user` SET `password`=MD5('yourpassword') WHERE `username`='admin'

In above code replace yourpassword with your password.