Skip to content

Instantly share code, notes, and snippets.

@zeloc

zeloc/change_user_pass.sql

Created August 16, 2018 08:14
Show Gist options
  • Save zeloc/d95a6a870d6720cd69acd96411980a87 to your computer and use it in GitHub Desktop.
Save zeloc/d95a6a870d6720cd69acd96411980a87 to your computer and use it in GitHub Desktop.
Download ZIP
Changes the user password in magento 2
Raw
change_user_pass.sql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment