Magento: How to reset admin pssword

Reset magento admin password with SQLIf 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.

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

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

Posted in Magento, Small Tips, SQL Tagged with: , ,
0 comments on “Magento: How to reset admin pssword
1 Pings/Trackbacks for "Magento: How to reset admin pssword"
  1. […] So that is all you can now start using you new shop. If you have problems logging in to Magento back-end because you don’t know the admin password you can restart Magento admin password. […]

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



It is necessary to help others, not only in our prayers, but in our daily lives. If we find we cannot help others, the least we can do is to desist from harming them. — Dalai Lama