Create a new WordPress admin user in the database

You can create a new WordPress admin user from within the database. Use this method if your original admin user was

  1. Log into phpMyAdmin (cPanel / Plesk / Web & Classic / Managed WordPress).

    Note: If you're using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before proceeding to the next step

  2. Click the _users table
  3. Click the Insert tab
  4. Fill in the following fields.
    • ID is any number you choose
    • user_login is the username for accessing the WordPress Dashboard.
    • user_pass is the password for the user. Make sure to select MD5 in the functions menu
    • user_nicename is the nickname for the user
    • user_email is the email address you want to associate with this user
    • user_registered is the date and time for when this user is registered
    • user_status should be set to 0
    • display_name is the name that will be displayed for this user on your site
  5. Click the Go button
  6. Click the _usermeta table
  7. Click the Insert tab
  8. Fill in the following fields:
    • user_id is the ID you entered in the previous step
    • meta_key should be the phrase wp_capabilities
    • meta_value should be
      a:1:{s:13:"administrator";s:1:"1";}
  9. Click Go
  10. Click the Insert tab again
  11. Enter the following information:
    • user_id is the same number you entered in the previous step
    • meta_key should be the phrase wp_user_level
    • meta_value should be the number 10
  12. Click the Go button.

You can now login with the new Admin user.

More Info


Var den här artikeln till hjälp?
Tack för din feedback. Ring vårt supportnummer eller starta chattalternativet ovan om du vill prata med en medarbetare på kundtjänst.
Vi är glada att vi kunde hjälpa till! Finns det något mer vi kan göra för dig?
Det var tråkigt att höra. Berätta vad som var krångligt eller varför lösningen inte hjälpte dig med problemet.