0

My client forgot admin password.

We use magento 2.1

How can change password in database?

Thank you.

2 Answers 2

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?

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

Magento2 you can use this command to set admin password

/bin/magento admin:user:create --admin-user="admin" --admin-password="Abc@123456" --admin-email="test@example.com" --admin-firstname="Admin" --admin-lastname="Admin"

Your Answer

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

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