Magento Expert Forum - Improve your Magento experience

Results 1 to 18 of 18

How to reset Magento Admin Password?

  1. #1
    Junior Member jaredovi's Avatar
    Join Date
    Mar 2013
    Posts
    68
    Thanks
    2
    Thanked 14 Times in 11 Posts

    Thumbs up How to reset Magento Admin Password?

    To change your Magento admin password, go to your cPanel > phpMyAdmin, select your Magento database, click the SQL tab and paste this query:

    Code:
    UPDATE admin_user SET password=CONCAT(MD5('newpasshere'), ':np') WHERE username='AdminUsername';
    Note: You have to change newpass in the MD5('newpasshere') with your new password, and change *AdminUsername* to your Magento admin username.

    Execute the query by clicking the Go button and your password will be changed.

    View more threads in the same category:


  2. #2
    Junior Member
    Join Date
    Mar 2016
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    How to reset the Magento administrator password
    This article describes how to reset the Magento administrator password.

    Normally if you forget your password, you can use the Magento password recovery feature to reset the password by e-mail. However, if this option is unavailable (for example, if e-mail on your site is not working correctly), you can use phpMyAdmin to manually reset the password in the database.

    Table of Contents
    Method #1: E-mail
    Method #2: phpMyAdmin
    Magento 2
    Magento 1.9 and older versions
    Method #1: E-mail

    The quickest and easiest way to reset the Magento administrator password is to request a new one through e-mail. To do this, follow these steps:

    Use your web browser to go to the Magento login page.
    Click Forgot your password?.
    In the Email Address text box, type the e-mail address associated with the account.
    Click Retrieve Password. Magento sends a message to the e-mail address associated with the administrator account.
    In the message, click the link to reset the administrator password.
    Method #2: phpMyAdmin

    You can also modify the Magento administrator password directly in the database using phpMyAdmin. To do this, follow the appropriate procedure for your version of Magento.

    Magento 2

    To reset the administrator password directly in the Magento 2 database, follow these steps:

    Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
    In the Databases section of the cPanel home screen, click phpMyAdmin.
    In the left-hand pane of phpMyAdmin, click the Magento database. A list of tables in the database appears.
    Typically, the Magento database is username_mageXXX, where username represents your cPanel username, and XXX is a three-digit number.
    On the top menu bar, click SQL.
    Copy and paste the following statement into the SQL query text box. Replace NewPassword with the new password, and replace both occurrences of xxxxxxxx with any random character sequence:
    UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';
    This command assumes that you want to change the password for the admin user account. To change the password for another account, change the username field to the correct value.
    The xxxxxxxx character sequence is a cryptographic salt. It can be anything you want (and any length you want), but make sure you use the same value in both parts of the SQL statement.
    If your Magento installation uses table prefixes, make sure you add it to the table name. For example, if your Magento table prefix is mg_, you would type the following command instead:
    UPDATE mg_admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';
    Click Go. phpMyAdmin updates the database, and you can log in to Magento as the administrator using the new password.
    Magento 1.9 and older versions

    To reset the administrator password directly in Magento 1.9 and older versions, follow these steps:

    Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
    In the Databases section of the cPanel home screen, click phpMyAdmin.
    In the left-hand pane of phpMyAdmin, click the Magento database. A list of tables in the database appears.
    Typically, the Magento database is username_mageXXX, where username represents your cPanel username, and XXX is a three-digit number.
    On the top menu bar, click SQL.
    Copy and paste the following statement into the SQL query text box. Replace NewPassword with the new password, and replace both occurrences of xx with any random two-character sequence:
    UPDATE admin_user SET password = CONCAT(MD5('xxNewPassword'), ':xx') WHERE username = 'admin';
    This command assumes that you want to change the password for the admin user account. To change the password for another account, change the username field to the correct value.
    The xx two-character sequence is a cryptographic salt. It can be anything you want, but make sure you use the same value in both parts of the SQL statement.
    If your Magento installation uses table prefixes, make sure you add it to the table name. For example, if your Magento table prefix is mg_, you would type the following command instead:
    UPDATE mg_admin_user SET password = CONCAT(MD5('xxNewPassword'), ':xx') WHERE username = 'admin';
    Click Go. phpMyAdmin updates the database, and you can log in to Magento as the administrator using the new password.

  3. #3
    Junior Member clapcreative's Avatar
    Join Date
    Jul 2015
    Location
    149 Mcafee court , Thousand Oaks CA 91360
    Posts
    115
    Thanks
    3
    Thanked 6 Times in 6 Posts

    Default

    The quickest and easiest way to reset the Magento administrator password is to request a new one through e-mail. To do this, follow these steps:

    Use your web browser to go to the Magento login page.
    Click Forgot your password?.
    In the Email Address text box, type the e-mail address associated with the account.
    Click Retrieve Password. Magento sends a message to the e-mail address associated with the administrator account.
    In the message, click the link to reset the administrator password.

  4. #4
    Junior Member
    Join Date
    May 2016
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I didn't even know it's possible! Thanks for the info!

  5. #5
    Expert
    Join Date
    Mar 2016
    Location
    india
    Posts
    570
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Hi,

    down vote
    accepted


    Go To :

    1 - Login in to PhpMyadmin .

    2 - Jump in to Magento's database .

    3 - Go to admin_user table and edit the table .

    4 - put a "password" (which you want) and select MD5 from function dropdown (Important).

    This is working both in CE And EE latest version (tested in both latest version), no need of core file changes.

  6. #6
    Contributor
    Join Date
    Apr 2016
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

  7. #7
    Expert
    Join Date
    Mar 2016
    Location
    india
    Posts
    570
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default Reset the administrator password directly in the Magento 2 database, follow these

    Hi,
    Magento 2

    To reset the administrator password directly in the Magento 2 database, follow these steps:

    Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
    In the Databases section of the cPanel home screen, click phpMyAdmin.
    In the left-hand pane of phpMyAdmin, click the Magento database. A list of tables in the database appears.
    Typically, the Magento database is username_mageXXX, where username represents your cPanel username, and XXX is a three-digit number.
    On the top menu bar, click SQL.
    Copy and paste the following statement into the SQL query text box. Replace NewPassword with the new password, and replace both occurrences of xxxxxxxx with any random character sequence:
    UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';
    This command assumes that you want to change the password for the admin user account. To change the password for another account, change the username field to the correct value.
    The xxxxxxxx character sequence is a cryptographic salt. It can be anything you want (and any length you want), but make sure you use the same value in both parts of the SQL statement.
    If your Magento installation uses table prefixes, make sure you add it to the table name. For example, if your Magento table prefix is mg_, you would type the following command instead:
    UPDATE mg_admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';
    Click Go. phpMyAdmin updates the database, and you can log in to Magento as the administrator using the new password.
    Magento 1.9 and older versions

  8. #8
    Junior Member
    Join Date
    Dec 2016
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    http://magentodevelop.com/author/admin/
    follow to this link,
    It should help you!

  9. #9
    Senior Member
    Join Date
    Aug 2018
    Posts
    107
    Thanks
    1
    Thanked 4 Times in 4 Posts

    Default

    To reset the administrator password directly in the Magento 2 database, follow these steps:
    Log in to cPanel. ...
    In the Databases section of the cPanel home screen, click phpMyAdmin.
    In the left-hand pane of phpMyAdmin, click the Magento database. ...
    On the top menu bar, click SQL

  10. #10
    New member
    Join Date
    May 2018
    Location
    New York
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hello, I'm Casey R. Carter from JSON formatter team. Our projects are: roll the ball and Impossible game . Hope your help, thank you!
    I need you to contribute all your ideas so I can improve it better

  11. #11
    Junior Member aishwaryaV's Avatar
    Join Date
    Sep 2018
    Location
    Noida, India
    Posts
    31
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Since I am not knowing that for which version you require password recovery method. I am telling you for latest version and the older versions as well.

    Magento 1.9 and older:

    UPDATE admin_user SET `password` = md5('YOUR_NEW_PASSWORD'), is_active = 1 WHERE `username` = 'YOUR_ADMIN_USERNAME';

    Magento 2:

    UPDATE admin_user SET `password` = CONCAT(SHA2('xxxxxxxxYOUR_NEW_PASSWORD', 256), ':xxxxxxxx:1') WHERE `username` = 'YOUR_ADMIN_USERNAME';

  12. #12
    Junior Member
    Join Date
    Sep 2019
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Use the 'Reset password' functionality. This is the most common and easy way which everyone would try it as the first option. ...
    Reset password using the Magento admin backend. ...
    Change the password using n98-magerun. ...
    Insert a new password using PHPMyAdmin. ...
    Insert a new password using the mysql client.

  13. #13
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    156
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Default

    In the location bar of your program, enter the URL that was determined during the Magento establishment, trailed by the base URL of your store's Admin. The default Admin URL resembles this: http://www.mystore.com/administrator. You can bookmark the Admin Login page for simple access.

  14. #14
    Junior Member emmaalfie's Avatar
    Join Date
    Aug 2019
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Finally I find it. Thanks

  15. #15
    Junior Member
    Join Date
    Sep 2019
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Use the 'Reset password' functionality. This is the most common and easy way which everyone would try it as the first option. ...
    Reset password using the Magento admin backend. ...
    Change the password using n98-magerun. ...
    Insert a new password using PHPMyAdmin. ...
    Insert a new password using the mysql client.

  16. #16
    Expert
    Join Date
    Apr 2017
    Location
    Ahmedabad, India
    Posts
    318
    Thanks
    3
    Thanked 3 Times in 2 Posts

    Default

    Methods to Reset Magento 2 Admin Password:

    Reset Magento 2 admin password via command line
    Reset Magento 2 admin password via Email
    Reset Magento 2 admin password from Account Settings

    For the implementation of each step, Contant our team for Magento 2 eCommerce Development Solutions

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •