Crucial Hosting

How to reset your Magento admin password

If you forget your login information for the Magento backend, here's how to reset your password.

  • Applies To: All Services
  • Difficulty: Easy
  • Software Required: Magento
AWS
This article was last updated on November 4th, 2015

If you ever forget your username and/or password to access the backend of Magento, and the "forgot your password" link isn't mailing you your information, you can easily update the password like so:

  1. Open up phpMyAdmin by accessing your site's cPanel.
  2. Click on your database name for Magento from the sidebar on the left.
  3. Click on the SQL tab and type the following in to the text box:
UPDATE `admin_user` SET `password` = MD5('PASSWORD') WHERE `username` = 'USERNAME';

You'll want to replace the capitalized values with the correct information:

  • USERNAME - The user whose password you'll be updating
  • PASSWORD - The new password you want to use

For example, if your username was admin and you wanted to reset the password to 123456, you would do this:

UPDATE `admin_user` SET `password` = MD5('123456') WHERE `username` = 'admin';

If you don't know the name of the user you want to update, you can see all the users by clicking on the admin_user link from the sidebar, and then select the Browse tab. The username column has the list of available users.

Professional hosting platform starting at $10/mo

View Plans