I deleted user 1 by mistake with all users

By interweb on 23 Feb 2008 at 19:05 UTC

Hi,

I deleted all users including user 1 by mistake. Now, I can't access the administrator page when I login. What can I do to solve this ?

Thank you

Comments

replace it

sepeck commented 23 February 2008 at 20:36

See the Troubleshooting-FAQ Handbooks

Deleted first user account?

-Steven Peck
---------
Test site, always start with a test site.
_{Drupal Best Practices Guide -|- Black Mountain}

-Steven Peck
---------
Test site, always start with a test site.
_{Drupal Best Practices Guide}

Thank you

interweb commented 23 February 2008 at 21:42

But to do that (change the newly created user to user no 1), I need to log in. And I can't log in without a username and password... I'm new with Drupal, so maybe I'm missing something here...

Thanks again !

database

sepeck commented 23 February 2008 at 21:44

As an alternative, how recent is your backup and is it tested? If you do not have any other users, you can setup a test Drupal site and copy the user from that one and insert it into your database.

-Steven Peck
---------
Test site, always start with a test site.
_{Drupal Best Practices Guide -|- Black Mountain}

-Steven Peck
---------
Test site, always start with a test site.
_{Drupal Best Practices Guide}

=-=

VM commented 23 February 2008 at 21:49

use your db tool

INSERT INTO users (uid, name, pass) VALUES ('1', 'yourname', md5('yourpassword'));

(Use your table name prefix (if any) and your username, password and email.)
When you log in go to user/1 and fill-in any other missing details.

Solved !

interweb commented 26 February 2008 at 04:15

1- I had no backup and now I have one (and I wasn't working with a test site).
2- Working directly with the database is new to me but is the way to go.

Thanks again !