Magento2 Password Reset Query Not working

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

this above query is not working


Right Answer is

For Magento 1.9 and older:

UPDATE admin_user SET `password` = md5('YOUR_NEW_PASSWORD'), is_active = 1 WHERE `username` = 'YOUR_ADMIN_USERNAME';

For Magento 2

UPDATE admin_user SET `password` = CONCAT(SHA2('xxxxxxxxYOUR_NEW_PASSWORD', 256), ':xxxxxxxx:1') WHERE `username` = 'YOUR_ADMIN_USERNAME';

Similar questions

Annoying reset password error "Cannot save a new password" on Magento
I am currently working with Magento and i am getting a strange behaviour from the reset password functionality. When I try resetting my password, I end up getting the following error "Cannot save a new password." but when I follow the same steps on a different account, it works. The accounts are exactly the same, the only difference is the...
Magento Reset Password Link not working after upgrade
My client had upgraded magento version in his site recently. But after upgrade whenever the customers try to reset their passwords they get link in their email, and when they click on the link they are redirected to forgot password page with error "Your password reset link has expired". I have checked in Admin panel at System > Configuration > Adva...
magento1.9 version password reset link not working
log: [Thu Oct 29 19:23:51 2015] [warn] [client] mod_fcgid: stderr: PHP Fatal error: Call to a member function setEmailValue() on a non-object in /var/www/vhosts/ on line 688 error line : 688: forgot password link server error 500 http://far...
Password reset link not working showing expired
When I'm trying to reset password through reset link from my mail, it's showing following error: Your password reset link has expired. When I check my password reset link it looks like: the reset password token is not generating I've checked the reset password template and it's loo...
Reset password not working, shows maintenance page
I have recently updated my Magento installation to version 1.9.3 (from 1.9.2) Sadly, since this update, my customers can no longer reset their passwords, which makes the usage of those who forgot their password impossible. I tried many of the suggested solutions on this site, but with no success so far. The current flow and the problem What I tried...
Magento reset password not working
I updated my website from to When a customer tries to reset their password the following error occurs: Invalid method Mage_Customer_Model_Customer::changeResetPasswordLinkCustomerId(Array ( [0] => 357371f4c2ad1a03dd768e865dc63b1a ) ) Any tips on how to fix this?

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.