By Mag007 on

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

bertboerland’s picture

bertboerland commented

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

taum’s picture

taum commented

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

Steven’s picture

Steven commented

Try this:

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