Latest From The Blog

Service announcements and product updates from the Mad Capsule team

Mark

Manually resetting a Magento user password via MySQL

August 23rd, 2011 by Mark in Magento

This shouldn't ever really be needed except in the following scenario(s).... You don't have current access to an admin account. You are running Magento on a localhost/computer that has no internet access to send out reset passwords. Or you need to reset a password that requires that the email address registered no longer exsists. Anyway it's pretty simple but to stop you hunting for tables and columns... In 1.5x

UPDATE admin_user SET PASSWORD=MD5('newpassword') WHERE user_id='x'

In previous versions

UPDATE admin_user SET PASSWORD=MD5('newpassword') WHERE user_name='x'


Magento Password mysql reset
Note due to the nature of MD5 you cannot select or view the passwords saved in the database, with the exception of some simple passwords can be 'cracked' with some tools out there, but thats another conversation completely. Hope this can help somebody.

comments powered by Disqus

OUR AUTHORS

Mark
Mark

I like the Sea, Monkeys, the Internet and sun. I don't like olives

James
James

Less QQ more pew pew

Israel
Israel

I love time travel, infact I'm writing this from the 1920s

CATEGORIES