Lost Administrator Password
Mag007 - December 20, 2004 - 01:09
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!
try to alter the passwd
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
hmmm...
I'm using MySql and that doesn't seem to be working.
Anybody have any other suggestions?
SQL statement
Try this:
UPDATE users SET pass = MD5('new password') WHERE uid = 1;