I set up drupal with the administrator account named "admin". I created a fair amount of content using this account. Then I decided that I wanted to have the administrator account be named "dewey", so I renamed the account.

I can no longer log in. I have tried to have my password reset using the "dewey" user name and the email address, but none of the passwords work with either the name "dewey" or the name "admin".

I have access to "user" (or anything else for that matter) in the mysql database. Is there anything I can do there to reset the password?

Comments

dewey’s picture

I set up another drupal installation, and copied all of the information from user 1 in the new database to user 1 in the loe database. I was then able to log on to the old drupal with the new password.