Create a new WordPress admin user in the database

If you want to add a new admin user to your WordPress account, this can be done from within the database.

Please note: this process applies to our Web Hosting and Premium Hosting products.

 

Step 1 of 12

Log into phpMyAdmin.

 

Step 2 of 12

Find the database for your WordPress website from the left-hand menu and expand the options by selecting the + icon that appears next to it.

Database

 

Step 3 of 12

Once done, select the wp_users option.

Users

 

Step 4 of 12

On the next page, select the Insert tab from the navbar.

Insert

 

Step 5 of 12

Enter as much as you can into the following fields:

  • ID: any number you want
  • user_login: your WordPress username.
  • user_pass: the password for the user. You’ll also need to select MD5 from the Functions menu
  • user_nicename: the nickname for this user
  • user_email: the email address you want to use for this user
  • user_registered: the date and time when this user was registered
  • user_status: this must be set to 0
  • display_name: the name that will be displayed for this user

Create User

 

Step 6 of 12

Once you’ve input these details, select Go to confirm this information.

 

Step 7 of 12

From there, select the wp_usermeta option from the left-hand menu.

usermeta

 

Step 8 of 12

On the next page, select the Insert tab from the navbar.

Insert

 

Step 9 of 12

Complete the following fields:

  • user_id: the ID you entered in the _users form
  • meta_key: enter the phrase wp_capabilities. If you use WordPress Hosting or a custom database table prefix, you’ll need to include that unique prefix in this phrase, which can be found in the left-hand column on the current page. For example, wp_ExamplePrefix_capabilities
  • meta_value: this should be the sentence a:1:{s:13:”administrator”;s:1:”1″;}

metauser

 

Step 10 of 12

Once done, select Go to confirm this information.

 

Step 11 of 12

Select the Insert tab once more and enter the following information:

  • user_id: the same number you entered in the _usermeta table
  • meta_key: enter the phrase wp_user_lev
  • meta_value: this must be set to 10

metauser

 

Step 12 of 12

Once done, select Go to confirm this information. You can now login as the new Admin user.