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