WordPress – Create admin account via the database

Bloom Email Optin Plugin

 

If your WordPress site gets hacked and your password gets changed or you forget your administrator password dont fear as its easy to create a new admin user account from the database in this tutorial we will show you how easy this is with your web hosting control panel and PHPMyAdmin.

 

In this tutorial the we hosting control panel we will be using is cPanel.

If your website is being hosted with a different panel such as Sentora or Plesk please search our site for tutorial on how to access PHPMyAdmin on that panel.

 

1. Login to your cPanel account

2. Go to the Databases section and click on “PHPMyAdmin”

3. Select your WordPress Database

4. Go to the wp_users table and click on “insert”

5. Now fill in the table entry

  • ID – Keep the value of this field empty (the value will be automatically assigned)
  • user_login – insert the username you want to use
  • user_pass – add a password for the account. Select MD5 in the functions menu
  • user_nicename – you can leave this field empty
  • user_email – add the email address you want to use for this account.
  • user_url – you can leave this field empty
  • user_registered – select the date/time for when this user is registered
  • user_status – set this to 0
  • display_name – leave this field empty for now

6. Click on the “Go” Button, if successful you should receive a success message

7. Now you should be back at the wp_users table where you can see all the entries for this table, take note of value if the “ID” field as we will need it in the next step

8. Go the the wp_usermeta and click “insert”

9. Use the following values for the new table entry

  • unmeta_id – Keep the value of this field empty (the value will be automatically assigned)
  • user_id – This is the ID of the user we created in the previous step.
  • meta_key – Use wp_capabilities
  • meta_value – Use the following value for this field:  a:1:{s:13:”administrator”;s:1:”1″;

10. Click on the “Go” Button, if successful you should receive a success message. now you should be able to login to you WordPress site with the new account that you just set up