If you forget your admin password for Magento and you can’t remember the email or just want quick fix you can use one line of SQL to sort that issue out.
[cc lang=”sql”]UPDATE admin_user SET password=CONCAT(MD5(‘qXpassword’), ‘:qX’) WHERE username=’admin’;[/cc]
All you have to do is replace the “password” with your required one and run the query.
Just a guy with strong interest in PHP and Web technologies
Very helpful tot..thanks