Ahmad Reshad Zazai Ahmad Reshad Zazai - 1 month ago 22
PHP Question

Magento admin password

I needed to change magento admin password so I went through following steps:

1)I exported the admin_user table into mydocumnets.

2)I run this Query:

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';
and changed the password.

3)The new password did't work so I dropped the admin_user table and imported the already exported one but the previous password did not work too.

4)I manual changed the email address in admin_user table and using forgot password got a link to reset the password in my inbox and reseted the password but I could not log in using that password.

5) The password which is showing in env.php file is different from the one I set.

Now, I can't login to the admin panel and I am getting error 504 Getway time-out in customer view.

Anyone can help?

Thanks.

Answer

Can you show your admin_user table before adn after updating? Not all, just row with user, that you try to modify.

Also, try to use SHA2() instead MD5() in your SQL query. Tell please, if it works for you.