Magento 2: Reset Customer Password from Database

In this tutorial, you will go through how to reset customer password from database in magento2. This trick will be very useful and handy when you want to reset the customer password from database using mysql query.

Just change "YOURPASSWORD" below (keep the xxx:es) and voila!

UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('xxxxxxxxYOURPASSWORD', 256), ':xxxxxxxx:1')
WHERE `entity_id` = 1;

I hope you like this post, Please feel free to comment below, your suggestion and problems!

(Visited 22 times, 3 visits today)
Chandra Kumar

Hello World, I am Chandra Kumar from New Delhi, India. I am professionally developer, programmer and blogger. I am the founder of

0 Comment

Leave a Comment

Your email address will not be published. Required fields are marked *