Brian: Created page with "==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 re..."

2013-03-25T20:02:29Z

Created page with "==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 re..."

New page

==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.

How to Reset Magento Password - Revision history

Brian: Created page with "==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 re..."