[M2] - Change Password of Customer in Magento 2.

m2-change-customer-pass.md

Change Customer Password by SQL

• Change values:
  • DATABASE
  • EMAIL
  • PASSWORD

Code

USE <DATABASE>;

SET @email='<EMAIL>', @passwd='<PASSWORD>', @salt=MD5(RAND());

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