You can create a new WordPress admin user from within the database. Use this method if your original admin user was
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-hand column before proceeding to the next step
- Click the _users table
- Click the Insert tab
- Fill in the following fields.
- ID is any number you choose
- user_login is the username for accessing the WordPress Dashboard.
- user_pass is the password for the user. Make sure to select MD5 in the functions menu
- user_nicename is the nickname for the user
- user_email is the email address you want to associate with this user
- user_registered is the date and time for when this user is registered
- user_status should be set to 0
- display_name is the name that will be displayed for this user on your site
- Click the Go button
- Click the _usermeta table
- Click the Insert tab
- Fill in the following fields:
- Click Go
- Click the Insert tab again
- Enter the following information:
- user_id is the same number you entered in the previous step
- meta_key should be the phrase wp_user_level
- meta_value should be the number 10
- Click the Go button.
You can now login with the new Admin user.
More Info