Unable to Sign in to WordPress?

If you cannot reach your WordPress dashboard or do not receive a password reset email, you might have to take extra measures to regain access.

To modify, remove, reset, or add a user in WordPress by yourself, identify the relevant situation from the options below and follow the corresponding instructions.

Update WordPress Password

You can change your WordPress password in a few different ways. Usually, this can be done directly from your WordPress dashboard. However, if you’re unable to get into your WordPress dashboard, there are other options available too.

To learn more about these alternatives, follow the Hosting Column post Different Methods of Changing WordPress Password.

Update Email Address, Create or Delete a user

Instead of changing the password, you have the option to change a user’s email address, allowing them to get a password reset email. Additionally, it is possible to create a new Admin user.

1. Change an email address for another WordPress user

As a WordPress admin, you have the ability to modify another user’s email address. This is useful in situations where they are unable to access WordPress or are not receiving the email for password recovery.

 Note: These instructions are based on the premise that you can access the system as an admin user in WordPress.

  1. Log in to WordPress
  2. Click the Users link on the Admin toolbar
  3. Click on the user you want to update
  4. In the Contact info section, change the email address
  5. Scroll to the bottom of the page and click Update Profile

2. Delete a WordPress user

As an administrator of WordPress, you have the ability to delete user accounts from your website.

  1. Log in to WordPress.
  2. Click the Users link on the Admin toolbar.
  3. Place a check in the box next to the user you want to delete.
  4. From the Bulk Actions drop-down menu, select Delete.
  5. Click the Apply button.

3. Change a WordPress email address in the database

You have the option to change your WordPress email address directly in the database, which can assist you if you’re not getting the email to reset your password.

  1. Log into phpMyAdmin.

     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.

  2. Click on the _users table.
  3. Click Edit next to the user you want to update.
  4. In the Value column, delete the contents of the user_email box.
  5. Type your new email address into the same box.
  6. Click Go

4. Create an admin user in the WordPress database

It’s possible to add a new WordPress admin user directly through the database. Use this approach if your original admin account has been compromised or removed.

  1. Log into phpMyAdmin. 

    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:
FieldWhat it is…
IDAny number that isn’t already used by another user
user_loginUsername for accessing the WordPress dashboard
user_passPassword for this user Note: Make sure to select MD5 in the functions menu.
user_nicenameThe nickname for this user
user_emailEmail address for this user
user_registeredDate and time this user was registered
user_statusSet this to 0
display_nameName that will display for this user
  1. Select Go.
  2. Select the wp_usermeta table.
  3. Select Insert.
  4. Enter the following
FieldWhat it is…
user_idEnter the ID from step 4
meta_keyEnter wp_capabilities Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_capabilities).
meta_valueEnter the following:a:1:{s:13:”administrator”;s:1:”1″;}
  1. Select Go.
  2. Select the Insert tab again.
  3. Enter the following
FieldWhat it is…
user_idEnter the ID from step 4
meta_keyEnter wp_user_level Note: For Managed WordPress accounts or custom database table prefixes, include the prefix (e.g. wp_coolPrefix_user_level).
meta_valueEnter the number 10

4. Select Go.

The administrator can now log in using their username and password.

Thanks for visiting. For queries and suggestions, emails are welcome at learnweb@hostingcolumn.com.

Subscribe to Hosting Column for the latest updates and posts.