Lost Administrator Password

Posted by Mag007 on December 20, 2004 at 1:09am

Hello,
I just installed Drupal, and I lost the main Administrator password, however I have other accounts (users roles). How can I create a new account with FULL blown access. I am using postgresql as my RDBMS. Do I have to install Drupal all over again?

Thanks!

Comments

try to alter the passwd

Posted by bertboerland on December 20, 2004 at 9:47am

try to alter the passwd from within sql you might want to clear the password field for the user 1. then login again, change it ans make sure you never forget it again.

--

groets

bertb

--
groets
bert boerland

hmmm...

Posted by taum on January 5, 2005 at 5:25pm

I'm using MySql and that doesn't seem to be working.
Anybody have any other suggestions?

SQL statement

Posted by Steven on January 5, 2005 at 5:31pm

Try this:

UPDATE users SET pass = MD5('new password') WHERE uid = 1;

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