How to Reset Magento Password

How to Reset your Magento User Password

Everyone at one point or another has forget a password, lot of people also forget their Magento passwords.

So you will need to reset your password from within your database base

First figure out what database you are using, by checking your local.xml file.

grep -i 'dbname' app/etc/local.xml

resulting in

<dbname><![CDATA[magento]]></dbname>

So the database is magento in this example:

Now login to your database server and run:

use magento;

Now lets search for the username you need to update

SELECT username FROM admin_user;

Let say the admin_user was 'admin'

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';

Now you password will be updated.