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 Comment

Your email address will not be published.