Magento 2.x: How to reset Customer Password from Database
If you need to reset the password of a certain customer via Database, the following query will help you:
|
1 2 3 |
UPDATE `customer_entity` SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1') WHERE `entity_id` = 1; |
Just change ‘YOURPASSWORD’ above (keep the xxxxx).