Update password can be done via mysql query, simply just execute this query to update customer’s password :
<pre><code class="lang-php">UPDATE customer_entity SET password_hash = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';
</code></pre>
And this query for admin :
<pre><code class="lang-php">UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxTypeYourPasswordHere', 256), ':xxxxxxx:1') WHERE email = 'johndoe@example.com';
</code></pre>
Notes :
<ul>
<li>Change TypeYourPasswordHere by new password **without **removing xxxxxxx
</li>
<li>Change **<a href="mailto:johndoe@example.com" class="autolinkedURL autolinkedURL-email" target="_blank">johndoe@example.com</a> **by email of customer/admin.
</li>
</ul>

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

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

And this query for admin :

```php
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 \*\*johndoe@example.com \*\*by email of customer/admin.

Magento 2  -  Update Customer/Admin Password via Query

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


Fiko Borizqy

Fiko Borizqy

Magento 2 - Update Customer/Admin Password via Query