Resetting a customer password using SQL

Use the following SQL code to reset a customer’s password directly in your Magento 2 database.

SET @passwd='123456789', @salt=MD5(RAND());

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

SET @passwd='123456789', @salt=MD5(RAND());

UPDATE customer_entity

SET password_hash = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), ':', @salt, ':1')

WHERE email = 'test@example.com';

Resetting a customer password using SQL

Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.

Tags: customer Magento 2 password

The Magento Expert

Independent Magento developer & consultant

Resetting a customer password using SQL (Magento 2)