By 2Hearts on

Hi folks,
Here's a real dumb one; I have somehow gotten locked out of my admin account. I used it to set up a new user account to test some views. When I went to log back in to the admin, I can't! I've been using this account for the last 2 weeks without problem, and now I suddenly have an "invalid username or password" message. This is a standalone development system with no mail server. I am just learning Drupal, so have not gotten comfortable enough yet to have set up a secure back door.

Does amyone have a suggestion for getting in other than blowing away Drupal and re-installing it?

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

go into the database and check UID 1 in the user table. is it there?

2Hearts’s picture

2Hearts commented

Yes. It is there, along with an encoded password. Any way to decode or alter that pw? The DB is MySQL (WAMP, so I'm using PHPMyAdmin)

vm’s picture

vm commented

the password in MD5, you can use an MD5 decoder that can be found using google or encode a new one.

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
commented

In phpmyadmin, you can run the following sql query:

UPDATE users SET password = md5('newpassword') WHERE uid = 1;

Replace 'newpassword' with the password of your choice of course, after this, you should be able to log in.

2Hearts’s picture

2Hearts commented

Thank-you, gentlemen. I'm back in and (duh) am setting up a back door as we "speak". It's an isolated development system so who cares about security!

Thanks again.