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!
User Comments
RD
On February 16, 2009 at 10:41 am
For some reason this is not working for me.
RD
On February 16, 2009 at 11:06 am
This alone will not work if localhost is the host name.
What I discovered was the problem in my case was accessing the site from localhost. I read about it here:
http://www.nickbartlett.com/wordpress/magento-cannot-log-into-admin/
You either have to add an entry to your hosts file, or access your local machine through a dynamic dns service. Both worked for me. To my hosts file, I just added:
127.0.0.1 http://www.localhost.loc
then used http://www.localhost.loc as the hostname of course.
Kurzweil4
Andrew Clarke
On February 26, 2009 at 12:00 pm
If you have forgotten your password you can use this tool http://md5encryption.com/ to encrypt a new one and enter it into the user you wish to change through phpmyadmin
I used it and it worked fine as the above failed for me.
Kevin
On May 14, 2009 at 9:32 am
I went into PHPadmin and just pasted my new hashed password in after using an MD5 hash generator I found on the web. Worked.
PAJ
On May 14, 2009 at 9:39 am
agreed, MD5 hash needed, insert as plain text in phpadmin and ensure not using intranet address, netbios name or localhost to connect to magento and login.
Jane
On July 2, 2009 at 7:19 am
This worked for me! Cheers!
Hendy
On August 28, 2009 at 3:24 am
Thanks a lot, it works for me
Anonymous
On February 12, 2010 at 10:02 pm
I just cannot believe that this situation is possible
)) I have mag. on a local machine, pressed “Retrieve password” and after that… I was locked outside the “house”… 
)) Many thanks, your solution worked great !
Post Comment