Magento 2: How to reset Customer Password from Database using SQL

Posted on December 9, 2020 by jamie

SET @email='test@gmail.com', @passwd='test@123', @salt=MD5(RAND());

UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), CONCAT(':',@salt,':1'))
WHERE `email` = @email ;