how to set a new admin Password of the existing admin user using MySql query?

UPDATE admin_user SET password = CONCAT(SHA2('cryptkeyPASSWORD@#$123', 256), ':cryptkey:1') WHERE username = 'USERNAME';

You can find the crypt key in the below file:


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