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.
-
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.
- In the left menu, select the wp_users table.
- Select Insert.
- 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 - Select Go.
- Select the wp_usermeta table.
- Select Insert.
- 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";}
- Select Go.
- Select the Insert tab again.
- 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 - 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.