dfelton · January 10, 2020 01:59
diff --git a/000 - Magento 2 Cheat Sheet.md b/000 - Magento 2 Cheat Sheet.md
diff --git a/customerPassword.sql b/customerPassword.sql
 -- Set customer password via the database
 SET @email='[email protected]', @passwd='test@123', @salt=MD5(RAND());

 UPDATE customer_entity
    SET password_hash = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), ':', @salt, ':1')
    WHERE email = @email;
	-- Set customer password via the database
	SET @email='[email protected]', @passwd='test@123', @salt=MD5(RAND());

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