How to Create a new WordPress admin user in the database

Sometimes you need to gain admin access to your WordPress site. There are a number of reasons for when this might become an issue:-

• Lost password and no longer have access to admin email address
• No longer have access to the developer who was the only admin
• Developer has left your company

1. Log into phpMyAdmin
2. Make sure you select the database for your WordPress site in the left-hand column
3. Click the _users table
4. Click the Insert tab
5. Fill in the following fields.
   • ID – any number you choose that isn’t already in use
   • user_login – username for accessing the WordPress Dashboard.
   • user_pass – password for the user. You must select MD5 in the functions menu
   • user_nicename – nickname for the user
   • user_email – email address you want to associate with this user
   • user_registered – date and time for when this user is registered
   • user_status – set to 0
   • display_name – name that will be displayed for this user on your site
6. Click the Go button
7. Click the _usermeta table
8. Click the Insert tab
9. Fill in the following fields:
   • user_id – ID you entered in the previous step
   • meta_key – enter wp_capabilities (If you have setup your site to use custom database table prefixes, then you need to include that prefix here (e.g. {CustomPrefix}_capabilities). You can see the prefix in name of each database table in the left-hand column on the current page.
   • meta_value – enter a:1:{s:13:”administrator”;s:1:”1″;}
10. Click Go
11. Click the Insert tab again
12. Enter the following information:
    • user_id – same number you entered in the previous step
    • meta_key – enter wp_user_level
    • meta_value – enter 10
13. Click the Go button.

You can now login with the new Admin user