If your site was hacked, you forgot your password, or for some reason, you cannot log in to your WordPress admin dashboard, do not despair. There’s another way to gain access – you can create a new WordPress admin user by directly editing your site’s database.
Time needed: 10 minutes.
Here’s how to create your new user…
- Step 1: Access your MySQL database
First, you’ll need to access a tool called phpMyAdmin so that you can edit your database. You can usually do so via a link in your hosting account dashboard.
The exact name varies depending on the host, but look for options such as:
Here’s what it looks like in cPanel:
- Step 2: Go to the wp_users table
Now, select your WordPress site’s database from the list of databases on the left. Then, click on the
Note – some hosts change the prefix of the
wp_userstable for security. For example, you might see it as
wpud_users. Just open the table that says
- Step 3: Insert a new WordPress admin user in the users table
wp_userstable, click on the Insert tab.
On the next screen you’ll see a form:
Fill in the following details:
user_login: Insert the username you want to use for your new admin user.
user_pass: Add a password for the account and select MD5 in the Function drop-down.
user_email: Add the email address you want to use.
user_registered: Select the date and time for when this user should be registered.
user_status: Set this value to zero.
Don’t worry about the other fields; leave them empty for now. Once you’ve filled out the fields, scroll to the bottom and click Go:
After clicking Go, you should see a success screen. If you go back to the
wp_userstable, you should see your new user. Pay attention to the value in the
IDcolumn as you’ll need this in the next step:
- Step 4: Insert user meta values
To finish things out, go to the
wp_usermetatable and click on Insert. Again, the name might be slightly different – just look for the table that says
Then, fill in the following values (again, leave the other fields empty):
user_id: Fill in the
IDof the user you created in the previous step.
meta_value: Fill in the field with
Click on Go to complete the user creation process. You can now log in to your WordPress site using the credentials from Step 3.
If you need more help, ask us below of this post!