My client forgot admin password.

We use magento 2.1

How can change password in database?

Thank you.

2 Answers 2


Follow this: https://www.siteground.com/kb/how_to_reset_admin_password_in_magento/

UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'ADMINUSERNAME';

Or you can follow this to create new admin user and when you logged in you can edit the old account How to reset lost admin password in Magento 2?

  • Also, check the lock_expires field as well...
    – KolonUK
    Commented Feb 12, 2019 at 12:48

Magento2 you can use this command to set admin password

/bin/magento admin:user:create --admin-user="admin" --admin-password="Abc@123456" --admin-email="[email protected]" --admin-firstname="Admin" --admin-lastname="Admin"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.