Knowledgebase
How to reset the Magento admin password
In this article we will show you how to manually reset your Magento admin password through phpMyAdmin.
To reset your Magento admin password, you need to log in to your phpMyAdmin and select the Magento database from the menu on the left. Then you should click the SQL tab in the top menu and paste the following MySQL query in the SQL query box:
UPDATE admin_user SET password=CONCAT(MD5('gDyourpassword'), ':gD') WHERE username='admin';
You need to replace yourpassword with the new password you want to set and admin with your actual administrative username. For example, if your admin username is MagAdmin and you want to reset its password to MyMagAdm1nPassw0rd, you need to paste the following query in the SQL box:
UPDATE admin_user SET password=CONCAT(MD5('gDMyMagAdm1nPassw0rd'), ':gD') WHERE username='MagAdmin';
To execute the query, click the Go button below the box. Once the query is executed, you will be able to log in to your Magento admin panel using the new password.Â