Updating Admin Password through SQL in Magento

Simply run following query from phpMyAdmin or from some other Database Manager panel which you’re using

UPDATE admin_user SET password=CONCAT(MD5(‘gD<Newpassword>‘), ‘:gD’) WHERE username=’<Username>‘;

Posted in:

Leave a Reply