---
title: "Discussion on \"Magento 2  -  Update Customer/Admin Password via Query\" | Hashnode"
description: "Discussion on \"Magento 2  -  Update Customer/Admin Password via Query\". Update password can be done via mysql query, simply just execute this query to update customer’s password :\nUPDATE customer_entity SET password_hash = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';..."
url: "https://hashnode.com/posts/magento-2-update-customeradmin-password-via-query/61a599d59ac0d611876b2b93"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Magento 2  -  Update Customer/Admin Password via Query](https://fiko.me/magento-2-update-customeradmin-password-via-query?utm_source=hashnode&utm_medium=feed)

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';...

Mar 23, 2020 · 1 min read · fiko.me  
Updated Sep 27, 2023  
Read the article

-   [#magento](https://hashnode.com/tag/magento)
-   [#magento-2](https://hashnode.com/tag/magento-2)
-   [#mysql](https://hashnode.com/tag/mysql)

## Written by

[Fiko Borizqy](https://hashnode.com/@fikoborizqy)

@fikoborizqy · Yogyakarta, Indonesia

  
[View profile](https://hashnode.com/@fikoborizqy)

Magento 2 Developer

I wrote these tutorials for myself in future when I forget for the next steps.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
