Skip to content

Instantly share code, notes, and snippets.

@mehdichaouch

mehdichaouch/fix_user_password.sql

Created April 5, 2022 16:45
Show Gist options
  • Save mehdichaouch/e76002128c3c45b794341eaf2a716d85 to your computer and use it in GitHub Desktop.
Save mehdichaouch/e76002128c3c45b794341eaf2a716d85 to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2 SQL snippet to reset admin password
Raw
fix_user_password.sql
# xxxxxxxx is the salt - it can change or stay like that
# admin123 is the password, you must change it
UPDATE admin_user SET `password` = CONCAT(SHA2('xxxxxxxxadmin123', 256), ':xxxxxxxx:1') WHERE `username` = 'admin';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment