Skip to content

Instantly share code, notes, and snippets.

@qaiserali

qaiserali/ResetAdminPasswordMySQL

Created December 4, 2017 09:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save qaiserali/15b2e61520dfc040d485413e3a9c1720 to your computer and use it in GitHub Desktop.
Save qaiserali/15b2e61520dfc040d485413e3a9c1720 to your computer and use it in GitHub Desktop.
Download ZIP
Reset admin password in magento via MySQL
Raw
ResetAdminPasswordMySQL
Magento 1.9
UPDATE admin_user SET `password` = md5('{New_Password}'), is_active = 1 WHERE `username` = '{Admin_User_Name}';
Magento 2
UPDATE admin_user SET `password` = CONCAT(SHA2('xxxxxxxx{New_Password}', 256), ':xxxxxxxx:1') WHERE `username` = '{Admin_User_Name}';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment