Unintentionally forgetting the admin password to your Magento shop can be harmful. Fortunately, security password restoration is a relatively easy process! In this post, we will move you through the procedure of recovering a Magento admin password. In this example we are using MySQL from the PHPMyAdmin.
To change your Magneto admin password:
Open your phpMyAdmin by accessing your site’s cPanel.
Select your Magento database.
Click the SQL tab and run the following query
UPDATE `admin_user` SET `password` = MD5('PASSWORD') WHERE `username` = 'USERNAME';
You have to change newpass in the MD5(‘PASSWORD‘) with your new password, and change *AdminUsername* to your Magento admin username.
Execute the query by simply clicking the Go button and your password will be modified.