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

Steven’s picture

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’s picture

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

tourbike’s picture

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

thx