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.
[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.

It's only fair to share...Buffer this pageShare on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Share on Reddit0Pin on Pinterest0Email this to someone

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 *