Magento 2 – Reset Admin Password SQL

Using bin/magento admin:create required lib-sodium. You can use SQL to change the password for an existing user here.

UPDATE admin_user SET password = CONCAT(SHA2('CRYPTKEY_FROM_ENV.PHPnewpassword1OK', 256), ':CRYPTKEY_FROM_ENV.PHP:1') WHERE username = 'admin'

 

Gareth

Back to Index