How to reset your Magento password
Everyone loses their keys at some point in their life, and not being able to login to your Magento e-commerce store is just like losing the keys to your shop (especially if for some reason the email reminders are not getting through to you)! This is how to reset your Magento admin/user passwords for anyone who is locked out of their store.
From within Plesk, open your Magento database via phpMyAdmin then click on the database name followed by the sql tab that appears at the top of the screen then run the following command:
SELECT * FROM admin_user;
Find the username you want to reset the password for then press the sql tab above and input the following code:
UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';
Now before clicking ‘Go’ to submit the command, change the ‘password’ part of ‘qXpassword’ to what you would like your password to be then submit it.
If you want to make this change for another user (ie: not admin) then you will also need to update this part of the command too.