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: , ,
One comment on “Magento: How to reset admin pssword
  1. jagdish says:

    Very helpful tot..thanks

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 *