Locked out of your Magento store? How to reset your login from phpmyadmin.
Everyone loses their keys at some point in their life, and not being able to login to your Magento e-commerce store is just like losing your keys to you’re shop (especially if for some reason the email reminders are not getting through to you)! I recently discovered how to reset your Magento admin/user passwords through phpmyadmin, so thought I’d share it for anyone who is locked out of their store.
1. Open phpmyadmin for your Magento database then do
SELECT * FROM admin_user;
and click ‘go’
2. Find the username you want to reset the password for then press the ’sql’ tab above and input the following code:
UPDATE admin_user SET password=MD5(’yournewpassword’) WHERE username=’yourusername’;
and click ‘go’
After completing these steps you should be able to login again and update your settings appropriately in the Magento admin interface. I hope this might be helpful to anyone in a jam with their Magento store!