WordPress.org

1. wildcard2092
   Member
   Posted 4 years ago #
   

   I recently accidently managed to remove the admin login from the database. Now I can't login and there is no user listed at all.

   Is there any query I can run through PHPMyAdmin that will make a new admin username/password?

   Thanks in advance!

2. wildcard2092
   Member
   Posted 4 years ago #
   

   Still looking for help.

3. wildcard2092
   Member
   Posted 4 years ago #
   

   Anyone?

4. Doodlebee
   Member
   Posted 4 years ago #
   

   Yeah, you can create a table by running an SQL query. I actually just did this last night for a site.

   INSERT INTO 'wp_usermeta'('umeta_id','user_id','meta_key','meta_value') VALUES
   (1, 1, 'nickname', 'admin'),
   (2, 1, 'rich_editing', 'true'),
   (3, 1, 'admin_color', 'fresh'),
   (4, 1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'),
   (5, 1, 'wp_user_level', '10');

   That should do it for you.

5. wildcard2092
   Member
   Posted 4 years ago #
   

   Thanks so much! You saved me a lot of stress.

Topic Closed

This topic has been closed to new replies.