While working as freelancer i have received many request and questions about How to reset admin password in Magento? The process to reset password is very simple, login to phpmyadmin and run the following query to reset magento admin password
UPDATE mag_admin_user SET password = CONCAT(MD5(‘nPpassword’), ‘:nP’)
WHERE username=’admin’;
mag_admin_user = Replace with your magento admin_user table name
nPpassword = Replace new password with just password (do not delete nP)
admin = Replace it with your magento username
About the author