Unable to reset Admin Password, Not even cpanel MyPhpAdmin

[eracha]

I am using Magento 2.1 and the password expired and was due for renewal. However, when trying to renew it didn't work. I have tried changing the pwd via cpanal Myphpadmin / SQL and it still won't work.

I will appreciate any leads on how to resolve this. I have read around and tried the recommended solutions and it seem not working.

Thanks

[Manish Mittal]

Hello @eracha

Replace password for now with below shared string:

c9df4cafa92ca21f5e8b268b5ad814c39e2101ada253a10c7abc7da7fe7948f2MQtXWrVgJ0YTkqOk70lL1rGYGlQ6M37:1

In the database "admin_user" table password filed for the selected username, and decoded value for this string is admin@123.

[Manthan Dave]

Hi @eracha

If you are not able to reset your password - i would suggest you to run below command from SSH terminal and create a new admin user for the same.

then after you will able to logged in using this user :

php bin/magento admin:user:create --admin-user="admin" --admin-password="admin@1234" --admin-email="test@test.com" --admin-firstname="Admin" --admin-lastname="User"

Hope it helps !

[Kavitha Mano]

Run below query to direct database.

An example is for reset password for admin user.

UPDATE admin_user SET `password` = SHA2('NewPassword', 256) WHERE `username`='admin';

NewPassword: Replace it with your password.