How to change administrator username/password

niko - July 28, 2004 - 14:41

Hei,

I accidentally forgot username & password of Administrator account
for drupal.
Is there a way to create a new account with SSH?

regards,
Andrei

» Login or register to post comments

Steven - July 28, 2004 - 15:38

Use the following SQL command to get the username:

SELECT name FROM users WHERE uid = 1;

To reset the password to use:

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

Replace your password with the desired password of course.

lkandarpa - August 15, 2009 - 19:15

This is perfect solution.. It worked for me.. thanks for posting this info

User login