zeloc
8/16/2018 - 8:14 AM

Changes the user password in magento 2

Changes the user password in magento 2

change_user_pass.sql
content_copyfile_download
SET @email='testspace@test.com', @passwd='Test@123456', @salt=MD5(RAND());

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