Knowledgebase: Magento
How To Reset Your Magento Password
Posted by Rick G. on 02 May 2015 11:42 AM

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 udpating
  • 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 theadmin_user link from the sidebar, and then select the Browse tab. The username column has the list of available users.

(1 vote(s))
This article was helpful
This article was not helpful