Creating WP User in PHPMyAdmin

  • 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!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter wildcard2092

    (@wildcard2092)

    Still looking for help.

    Thread Starter wildcard2092

    (@wildcard2092)

    Anyone?

    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.

    Thread Starter wildcard2092

    (@wildcard2092)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Creating WP User in PHPMyAdmin’ is closed to new replies.