How to reset Customer Password from Database in Magento 2

Magento 2 update customer password using the database:-

Run/execute below query in database

SET @email='[email protected]', @passwd='asd123', @salt=MD5(RAND());
UPDATE customer_entity
SET password_hash = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), ':', @salt, ':1')
WHERE email = @email;

Magento 2 update admin password using database:-

Run/execute below query in database

SET @salt = MD5(UNIX_TIMESTAMP());
UPDATE admin_user SET password = CONCAT(SHA2(CONCAT(@salt, 'admin@1234#'), 256), ':', @salt, ':1') WHERE username = '[email protected]';

How to get database detail in Magento 2

Like us on Facebook and Linkedin for more updates.