How to reset Magento Admin Password

How to reset 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(‘admin123’), ‘:sG’) WHERE username=’AdminUsername’;

Note: You have to change newpass in the MD5(‘admin123’) 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.