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.


The following steps apply to Managed WordPress plans purchased after May 2021:

Step 1 of 3

Start by accessing your Managed WordPress dashboard. For details on how to do this, please read our Support article: How do I access my Managed WordPress dashboard?

From there, select Users from the right-hand menu, followed by Add New.

Select Add New User


Step 2 of 3

Enter the necessary details for your user and be sure to set their Role to Administrator.

Enter details


Step 3 of 3

Once done, select Add New User to confirm your change.

Create new User


The following steps apply 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.



Step 3 of 12

Once done, select the wp_users option.



Step 4 of 12

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



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.



Step 8 of 12

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



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″;}



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



Step 12 of 12

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