WordPress.org

Ready to get started?Download WordPress

Forums

Creating WP User in PHPMyAdmin (5 posts)

  1. wildcard2092
    Member
    Posted 5 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 5 years ago #

    Still looking for help.

  3. wildcard2092
    Member
    Posted 5 years ago #

    Anyone?

  4. Doodlebee
    Member
    Posted 5 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 5 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.