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