how to set a new password for the existing customer using MySql query?

UPDATE customer_entity SET password_hash = CONCAT(SHA2(‘cryptkeyAdmin@#$123’, 256), ‘:cryptkey:1’) WHERE entity_id = 1;

You can find the crypt key in the below file:

Magento_Root/app/etc/env.php

‘crypt’ =>
[
‘key’ => ’82df4fe20ecf9af24614a2f6b76ac7b6′
]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>