Blog

Home RSS

Locked out of your Magento store? How to reset your login from phpmyadmin.

August 5, 2008 at 1:04 pm, Category: Uncategorized, Web Hosting, by Tom

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

  1. RD

    On February 16, 2009 at 10:41 am

    For some reason this is not working for me.

  2. 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

  3. 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.

  4. 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.

  5. 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.

  6. Jane

    On July 2, 2009 at 7:19 am

    This worked for me! Cheers!

  7. Hendy

    On August 28, 2009 at 3:24 am

    Thanks a lot, it works for me :D

  8. 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




By submitting a comment here you grant NuBlue Blog a perpetual license to reproduce your words and name/web site in attribution. Inappropriate comments will be removed at admin's discretion.