Magento password reset – Admin

It’s really easy to reset the password using mySQL

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 (tbl_prefix)_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.