Sometimes you have to take an alternative step to gain access to your WordPress dashboard. Probably you are unable to receive a password reset email, or you lost your password. There are two options to regain access to your WordPress account.

  • Submit our Free Quote form and one of our experts can do it for you for a fee.
  • Follow the instructions in the article below and do it yourself. You need to have cPanel access.

WordPress Premium Support

How to create a new WordPress admin user in the database

Our support experts can perform the following services for you for a fee:

  • Reset your WordPress password
  • Update a user’s email address in the WordPress database
  • Create a new WordPress admin user
  • Delete old or unused users
  • Replace a missing wp_users table

Create a new WordPress admin user in the database

Use this method to create a new WordPress admin user if your previous user role was admin too.

  1. Log into phpMyAdmin
  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.

Now you are able to log in with your new WordPress admin user.

Video with the steps

Important Note

You have to rename wp_capabilities and wp_user_level with your database table prefix. In my case for the video was test_ so the above will be renamed to test_capabilities and test_user_level. In any other case, you will not be able to log in to your WordPress site.

WordPress Support Services

Tired of slow WordPress hosting or your support is lacking?
We do things different at BakemyWP.

Get a Free Quote

Leave a Reply

Your email address will not be published. Required fields are marked *