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
Sometimes captcha fails to load on admin screen or if you want to disable it manually then try following steps to do so. Magento Disable Captcha Admin Login
Step 1: Login to your hosting control panel and go to following path app/etc/modules/ open & edit Mage_Captcha.xml
Step 2: Should have true value within <active> tag, just replace it with false as shown. Change the value from true to false and save file.
Result: Captcha on Magento Admin Screen is disabled now.
Please Note: If you still have captcha on admin login after completing these steps … Read More