Create an admin user in the WordPress database

You can create a new WordPress admin user from within the database. Use this method if your original admin user was corrupted or deleted.

1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress).

   Note: If you're using cPanel Hosting, you must select the database for your WordPress site in the left column before continuing to the next step.

2. In the left menu, select the wp_users table.
3. Select Insert.
4. Enter the following:

   Field	What it is...
   ID	Any number that isn't already used by another user
   user_login	Username for accessing the WordPress dashboard
   user_pass	Password for this user Note: Make sure to select MD5 in the functions menu.
   user_nicename	The nickname for this user
   user_email	Email address for this user
   user_registered	Date and time this user was registered
   user_status	Set this to 0
   display_name	Name that will display for this user



5. Select Go.
6. Select the wp_usermeta table.
7. Select Insert.
8. Enter the following:

   Field	Whatit is...
   user_id	Enter the ID from step 4
   meta_key	Enter wp_capabilities Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_capabilities).
   meta_value	Enter the following: a:1:{s:13:"administrator";s:1:"1";}



9. Select Go.
10. Select the Insert tab again.
11. Enter the following:

    Field	What it is...
    user_id	Enter the ID from step 4
    meta_key	Enter wp_user_level Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_user_level).
    meta_value	Enter the number 10



12. Select Go.

The admin user is now ready to log n with their username and password.

More Info

• Return to Unable to log into WordPress.
• For more information about our premium support for WordPress, please visit the WP Premium Support Catalog.