Fiko Borizqy
Fiko Borizqy

Fiko Borizqy

Magento 2  -  Update Customer/Admin Password via Query

Fiko Borizqy
·Mar 23, 2020·

1 min read

Subscribe to my newsletter and never miss my upcoming articles

Update password can be done via mysql query, simply just execute this query to update customer’s password :

UPDATE customer_entity SET password_hash = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';

And this query for admin :

UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';

Notes :

  • Change TypeYourPasswordHere by new password without removing xxxxxxx
  • Change by email of customer/admin.
 
Share this