Create a new WordPress admin user in the database
This article will show you how to add a new user on WordPress
If you want to add an admin to WordPress, this can be done from within the database.
Simply click on a title below to skip to the most appropriate FAQ. You can also click the Top button to return and make another selection.
Managed WordPress Hosting plans purchased after May 2021
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.
Enter the necessary details for your user and be sure to set their Role to Administrator.
Once done, select Add New User to confirm your change.
Web Hosting plans purchased after July 2020 / Premium Hosting plans purchased after August 2020 (cPanel)
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.
Once done, select the wp_users option.
On the next page, select the Insert tab from the navbar.
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
Once you’ve input these details, select Go to confirm this information.
From there, select the wp_usermeta option from the left-hand menu.
On the next page, select the Insert tab from the navbar.
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″;}
Once done, select Go to confirm this information.
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
Once done, select Go to confirm this information. You can now login as the new Admin user.