Skip to content

Instantly share code, notes, and snippets.

@yogeshdubey2006

yogeshdubey2006/magento2_reset_password.sql

Created December 29, 2018 11:26
Show Gist options
  • Save yogeshdubey2006/d987ded99881bda202c73ff00f57cac2 to your computer and use it in GitHub Desktop.
Save yogeshdubey2006/d987ded99881bda202c73ff00f57cac2 to your computer and use it in GitHub Desktop.
Download ZIP
Magento 2 Reset Customer Password through SQL
Raw
magento2_reset_password.sql
UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1') // change YOURPASSWORD to your password to reset
WHERE `entity_id` = 199 and `email`="[email protected]";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment