Printable View
To change your Magento admin password, go to your cPanel > phpMyAdmin, select your Magento database, click the SQL tab and paste this query:
UPDATE admin_user SET password=CONCAT(MD5('newpass'), ':newpass') WHERE username='AdminUsername';
Note: You have to change newpass in the MD5('newpass') 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.
To reset the administrator password directly in Magento 1.9 and older versions, 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
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
rom the web
Image result for How to reset Magento Admin Password
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.
Visit your Magento administrator backend in a program, and snap the connection Forgot your secret word. Next addition your email address and press the Retrieve Password button. An email will be send to your email address, containing a secret word reset connect. Snap the Reset Password connection, or glue the connection in your program.