How to reset Magento admin password

I installed Magento on my MacBook Pro a few months ago and came back to it today but had forgotten the admin password.

There are lots of articles on the internet on how to reset the admin password.

Whilst this works

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

it isn’t necessary to set a salt so this equally works

UPDATE admin_user SET password=MD5('password') WHERE username='admin';

I would also recommend clearing the relevant cookies and keychain entry on Mac’s.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: