How to Change Your WordPress Admin Password Within Your Database

WordPress > How To
Changing Your WordPress Admin Password Within Your Database
Issue

You've forgotten or lost your password for your WordPress admin account, and now you can't get in to edit your site.
 
Solution
There are four ways you can recover or change your admin password, and continue to work on your site.

Option 1: Use the WordPress Built-In Password Reset Feature
This option is the easiest. It requires the username or email address attached to the account that you are trying to reset the password for. It requires that you know the email address and password for the account associated with the WordPress admin account.
  1. In your URL bar go to http://yourdomainname.com/wp-login.php
  2. On this screen, click Lost Your Password?
    This will send a password reset link to your admin account's email address.
  3. Login to your email account for your admin account.
  4. Click the email from your WordPress site.
  5. Click the password reset link.
  6. On the next screen enter and confirm your new password click Reset.
  7. On the next screen click Log In.
  8. Use your admin username and the new password to login.
Option 2: Change the Password in the MySQL Database
This option requires knowledge of the Customer Control Panel, phpMyAdmin, and the WordPress database. It is not recommended to attempt this without familiarity in these areas. If you do not feel comfortable manually editing the database, or navigating the control panel, please follow the steps in Option 3.
  1. Login to your Control Panel. See How to Access Your Control Panel.
  2. Click on the System tab up at the top left.
  3. Navigate to Websites & Domains.
  4. Click on Databases.
  5. Click on the database for your WordPress site.
  6. Click on WebAdmin.
  7. Click on the wp_users table
    Note: Your database may have different prefixes on the tables, depending on how it was set up.
  8. Click on the Browse tab up at the top on the left side.
  9. Click on the user you wish to edit
    Note: The edit button will be to the far left at the beginning of the row.
  10. In the password field, select MD5 for the type, and enter in your new password.
  11. Click Go at the bottom.
  12. Go to your site's login and try your new password. If all went as expected, your new password should work, and you can login.
Option 3: Contact Support for Assistance
This option is for that situation when you can't get to your site to use the lost password link, or when you don't feel comfortable editing your database manually.
  1. Log in to your Control Panel. See How to Access Your Control Panel.
  2. Click the Help tab at the top.
  3. Click Trouble Tickets.
  4. Click Submit a Ticket.
  5. Click on SUPPORT: I have a technical issue that I need assistance with.
  6. Click Open a Ticket with the Support Team, then click next.
  7. In the application drop down, select the application you are using, in this case, WordPress.
    Enter in all of the information that you can provide in the fields provided.
    The only fields that are required are:
    • What your domain name is
    • What you are trying to do, in this case, you can leave it at the default, Control Panel
    • You'r preferred follow up method
    • Subject of the ticket
    • The message explaining what you are trying to do, and what you need help with in this case, please include the username you are trying to reset the password for.
  8. Click Submit at the bottom.
  9. We will begin working on your ticket very soon and you will be receiving your reply as soon as we are done, or if we need more information from you.
Option 4: Use Control Suite's Update WordPress User Password Button
This option is only available to dedicated server customers. 
  1. Log into your dedicated server using Remote Desktop
  2. Double click on the Control Suite icon on your desktop. 
  3. Login to Control Suite.
  4. Double click on the Plesk x.x.x (Domains) icon in the Navigation Tree.
  5. Double click on the [domain] that requires the password reset.
  6. Double click on WordPress x.x.x
  7. Double click on Administrators. Click on admin.
  8. Click on the Update WordPress User Password in the Commands Ribbon.
  9. Type the new password in the Main Window and press Execute.
Update WordPress User Password

Add Feedback