Reset Magento Admin Password

[55debra]

I have to reset my Magento Admin Password.
Is there any easy way to reset it?

[WebMaster]

A. Go to your cPanel > phpMyAdmin,
B. Select your Magento database,
C. Click the SQL tab and paste the following :

UPDATE admin_user SET password=CONCAT(MD5('sGnewpass'), ':sG') WHERE username='AdminUsername';

D. Select “Go”

Note:
Newpass in the MD5 = your new password
AdminUsername = your Magento admin username.

[deepak11627]

The default login is : admin The default password is : 123123

If you are having troubles and want to reset it to a different password, just run at your sql database:

SELECT * FROM admin_user;
Then, find the username you want to modify in the listing provided - ‘admin’ in this example. Then, to update the password, type:

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';
‘qX’ would be changed to whatever you want it to be and same goes for ‘password’

You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.

If you want to add a new admin user, you must not only create a new entry in the table ‘admin_user’, but you also have to insert an entry in the table ‘admin_role’ which has to be associated with the user by the field ‘user_id’.

Thanks
CoreIT Developers!

[rajan2907]

Slect your Magento Database

and run this query

UPDATE `admin_user` SET `password`=MD5(’mypassword’) WHERE `username`=’admin’;