WordPress: Reset your Password with phpMyAdmin | Bluehost Support
Support
  1. bluehost knowledge base

WordPress: Reset your Password with phpMyAdmin

Overview

This article explains how to reset a lost WordPress password using phpMyAdmin.

It is highly recommended that you back up your database before continuing if you don't know how to, please read How to Backup a MySQL Database.



What You Need

To perform this task, you will need the following items.

  1. The name of your WordPress database - If you aren't sure, please see How to find your WordPress Database.
  2. Your Bluehost cPanel username and password

Access phpMyAdmin

These steps explain how to access phpMyAdmin.

Note: Legacy accounts will feature a horizontal navigation bar at the top of the screen, while Bluerock account users will see a vertical navigation menu on the left-hand side of the screen. If you are still unsure of what interface your account uses, please see Bluerock vs. Legacy to determine which step to follow.

Bluerock

  1. Log in to your Bluehost control panel.
  2. Click the Advanced tab from the side navigation menu to the left.
    rock-bh-advanced-tab
  3. Under the Database section, select phpMyAdmin.
    Name of the article
  4. From the list of databases, select the database for your WordPress site.

Legacy

  1. Log in to your Bluehost control panel.
  2. Look for the Database tools section, and select phpMyAdmin.
    Name of the article
  3. From the list of databases, select the database for your WordPress site.

Enter a New Password

These steps explain how to change the password in the database.

  1. On the left side of your screen, you should be able to see the table list. But sometimes, you still need to expand each individual database to be able to see the tables. You can do so by clicking the sign until the _users table shows up.
    phpmyadmin-expand-tables

    Note: In our example, the table prefix is "ce8_" the prefix varies from site to site, so don't worry if yours is different.

  2. After clicking the _ user's table, options will pop up to the right.
    phpmyadmin-users
  3. Click the edit button next to the user you want to set the password for.
    phpmyadmin-users-edit
  4. Enter the new password into the password box in the user_pass line.
    phpmyadmin-users-password
  5. In the function drop-down box next to the password, choose MD5.
  6. Click Go

The password has been reset. You can now log in to WordPress with your new password.

To learn about resetting your password, please see Password Reset.

If you need further assistance, feel free to contact us via Chat or Phone:

  • Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
  • Phone Support -
    • US: 888-401-4678
    • International: +1 801-765-9400

You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.