If you forgot your password and you also forgot your email id to which recovered password will be sent or in case you are running magnento on local server and you forgot your password then there is a way by which you can reset your password.
For this you have to access your database tables via phpmyadmin etc. To change your Magento admin password go to your phpMyAdmin section then select database of your magento installation then run a query like below to update/reset admin user password:
UPDATE admin_user SET password=CONCAT(MD5('yournewpassword'), ':sG') WHERE username='yourusername';
Note: You have to change newpass in the MD5('sGnewpass') with your new password, and change *AdminUsername* to your Magento admin username.sg is the api key which u used during installation.
Execute the query by clicking the Go buttong and your password will be changed.
For this you have to access your database tables via phpmyadmin etc. To change your Magento admin password go to your phpMyAdmin section then select database of your magento installation then run a query like below to update/reset admin user password:
UPDATE admin_user SET password=CONCAT(MD5('yournewpassword'), ':sG') WHERE username='yourusername';
Note: You have to change newpass in the MD5('sGnewpass') with your new password, and change *AdminUsername* to your Magento admin username.sg is the api key which u used during installation.
Execute the query by clicking the Go buttong and your password will be changed.
Hi. Our team would like to share solution how to reset an administrator password or add a Magento admin user using MySQL. A good example of this topic is in the following article http://www.atwix.com/magento/reset-admin-password-mysql/
ReplyDeleteWe hope this is helpful advice