How can I change the admin password for my WordPress site using phpMyAdmin?


  • Applies to: All services
    • Difficulty: Medium
    • Time Needed: 10 minutes
    • Tools Required: phpMyAdmin

READ ME FIRST

This article is provided as a courtesy. Installing, configuring, and troubleshooting third-party applications is outside the scope of support provided by (mt) Media Temple. Please take a moment to review the Statement of Support.

For more detailed instructions on this and other WordPress topics, we strongly advise that you visit the WordPress Codex.

CloudTech_ProductPage_217x57

CloudTech Can Help!

If you’re having trouble with the steps in this article, additional assistance is available via CloudTech, our premium services division. Our expert engineers can tweak and tune your server for optimal performance. For more information on what CloudTech can do for you, please click here.

Overview

Occasionally, circumstances will arise in which you are unable to remember your WordPress admin password, and cannot reset your password using WordPress's integrated email functions. In these situations, it may be necessary to reset your password using phpMyAdmin. 

Instructions

    1. First, you'll need to log into phpMyAdmin and enter the MySQL database associated with your WordPress installation.
    2. Once in your database, select the wp_users table.
    3. From the wp_users table, click the checkbox for the user_pass field, then click the “Browse” tab.
    4. Find the ID number associated with your login (there is usually only one) and click Edit (pencil button).
    5. Select the password content and delete it. Type in your new password as you normally would.
    6. In the dropdown menu, choose MD5. This will encrypt your password with the proper hash:

1714_1

  1. Click the Go button at the bottom of the screen to save your changes.
  2. Return to the tab for your WordPress blog admin login page and test the new password. If it doesn’t work, start over.

Additional Resources