How to reset admin password in Magento 2?

In order to reset the admin password from phpmyadmin in Magento 2, please follow below simple steps.

1) Go to phpMyAdmin
2) Open table admin_user
3) Run the following sql query

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

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

Here, NewPassword -> Replace it with your password.

Thats it.

Write an article about ecommerce that help people to grow their ecommerce business. You’ll find best ecommerce guide, news, tips & more!