Community & Support

How to change administrator username/password

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

SQL commands

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.

drupal forgot admin password

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

using phpMyAdmin

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

thx