By niko on

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

Steven commented

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

lkandarpa commented

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

tourbike’s picture

tourbike commented

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

thx