I, too, am having issues with resetting the admin password. My problem did not stem from forgetting the admin password, rather from performing a MySQL dump and subsequent restore into a new magento database. After I restored the database, I attempted to login to the Admin Panel and received the ‘Access Denied’ message. The login information was not changed from the working database.
I have also attempted to use the suggestions here regarding running update on the password—both ways—by using “password=md5(’newpassword’)” and by creating an md5 hash from the ‘hashmash’ site and updating the string directly. Neither of these methods have worked.
What I have noticed is that the encrypted string is longer than what an md5 hash string would be by an extra 3 characters. Is Magento performing some other type of hashing?
I have multiple Magento databases and have also attempted to copy the encrypted string from another known database admin login. This did not work either. And, the encrypted string was also 3 characters longer than a normal md5 encrypted string.
Does anybody have any other ideas? This is the Magento 1.0 database. I must be missing something very, very important. In addition, I cannot, for the life of me, understand why a MySQL dump/restore would cause the login/password not to be acknowledged. If anybody has a suggestion, please let me know, as I really do not want to install everything from scratch and rebuild all our modifications.
When you installed magento it asked you for an encryption key - I believe that this is being used for storing sensitive data - i.e admin passwords… so using the md5hash function won’t help you. When you installed the 2nd time (before doing the mysql dump) did you specify the same encryption key? If not, then you need to change it.
You can open /app/etc/local.xml and change the key there to what you used when setting up magento.
Are you saying that if I have a separate instance of the magento application, which builds the database during installation, that I cannot drop this database instance and load a mysql dump into it without changing the encryption key in the ‘app/etc/local.xml’ file to match whatever the original magento application created?
If so, is the ‘key’ the only component that needs to be considered? The other elements deal with the database instance and may vary per instance.
I input the right password to my Admin login page, but I got the access denied.
Fogot your password is not working either on my local machine. what method shall I used to access to the Admin control panel?
All of a sudden when I go to login, I type in the correct information, and get resent to the login without any errors.
One issue other people may be having is that hitting “Forgot password” literally overwrites your old password instead of creating a temporary one. If you are still trying to use your old password, after someone hit “Forgot password”, you are no longer typing the correct one.
I had a similar problem after updating my database, although I have done an automatic installation therefore I haven’t entered any emails during installation. So when I wanted to retrieve a password it did not send any emails.
Then I went to php my admin and checked the admin_user field and saw that I was assigned a random email such as
I changed that with my real email and have magento sent a new password to me again.
You can also see the password there I guess in an encrypted mode but that’s beyond me, I dunno how to read that