Knowledgebase: Magento
Reset Your Magento Password
Posted by ASO Admin on 11 February 2020 11:14 AM

If you forget your Magento username or password that allows you access to the backend of Magento and the 'forgot your password' link isn't mailing you the information you need you can update the password yourself.

To reset your Magento password:

  1. Log into your cPanel account

  2. Navigate to and click into the phpMyAdmin section

  3. Click on your database name for Magento from the sidebar on the left

  4. Click on the SQL tab and type the following into 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

So, 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. The username column from within the Browse tab has a list of available users.
 

​Check out the rest of our Magento articles to get more info and help.

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

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion
ERROR: This domain name (kb.asmallorange.com), does not match the domain name in the license key file help.asmallorange.com.

For assistance with your license, please contact the Kayako support team: https://support.kayako.com