unable to reset user password

[dibsmcsIngh]

Dear Magento Team

I tried to reset the admin password in admin_user table via phpMyAdmin 5.6.16.

After unsuccessful attempts due to unable to pick SHA256 format from the phpMyAdmin gui,

how can i reset the password ?

I have limited with mySql knowledge.

thanks

Dibs 

[Damian Culotta]

Hi @dibsmcsIngh,

You can use the new Magento CLI.

If you know exactly the username and email registered for your user, you can execute this command:

bin/magento admin:user:create --admin-user="the_same_username" --admin-password="your_new_password" --admin-email="the_same_email" --admin-firstname="John" --admin-lastname="Doe"

Using the same username and email the password will be updated.