Skip to content

Instantly share code, notes, and snippets.

@GideonBabu

GideonBabu/magento2_reset_password.txt

Created October 23, 2018 13:47
Show Gist options
  • Save GideonBabu/b3f2f0e02c4d0119bf72674961768665 to your computer and use it in GitHub Desktop.
Save GideonBabu/b3f2f0e02c4d0119bf72674961768665 to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2 Reset Customer Password SQL query
Raw
magento2_reset_password.txt
UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1') // change YOURPASSWORD to your password to reset
WHERE `entity_id` = 19975 and `email`="gideon.b@domain.com";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment