How to change administrator username/password

Posted by niko on July 28, 2004 at 2:41pm

Hei,

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

regards,
Andrei

Comments

Posted by Steven on July 28, 2004 at 3:38pm

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.

--
If you have a problem, please search before posting a question.

Posted by lkandarpa on August 15, 2009 at 7:15pm

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

Posted by tourbike on March 7, 2010 at 5:41pm

what's the procedure for using phpMyAdmin as I am a bit thick

thx