Reset a WordPress Password with phpMyadmin
If you are using assistive technology and are unable to read any part of the HostMonster website, or otherwise have difficulties using the HostMonster website, please call 866-573-HOST and our customer service team will assist you.
Skip to main content
Search

HostMonster Web Hosting Help

Reset a WordPress Password with phpMyadmin

Overview

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

It is highly recommended that you make a backup of your database before continuing. If you don't know how 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 HostMonster cpanel username and password

Access phpMyAdmin

These steps explain how to access phpMyAdmin.

  1. From your account cpanel, go to the databases group of icons, and click on phpMyAdmin
  2. When prompted login with your cpanel username and password.
  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. In the table list, click on the users table
    Note: In our example the table prefix is "wp_" the prefix varies from site to site so don't worry if yours is different.
  2. Click edit next to the user you want to set the password for.
  3. Enter the new password into the password box
  4. In the function box next to the password choose MD5
  5. Click Go

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

Knowledgebase Article 203,746 views bookmark
share
Share or save this via:
tags: password phpmyadmin wordpress


Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

Password Reset
How to reset various passwords associated with your account
Knowledgebase Article 163,748 views tags: change password reset update

Change a MySQL Users Password
This article will explain how to change or reset the password for a MySQL user.
Knowledgebase Article 154,988 views tags: change mysql password reset user

How To Reset MySQL Database User & Password
This article will explain how to change the password for a database in the event that the original password is lost.
Knowledgebase Article 263,719 views tags: database mysql password

Related Help Content

How to Reset your FTP Password
How to reset the password for FTP users.
Knowledgebase Article 141,322 views tags: change ftp password reset update

Setting a Password for the Main MySQL User
I am prompted to set a new MySQL password. What does this mean and how do I change it?
Knowledgebase Article 249,374 views tags: connect database mysql password phpmyadmin username

Reset Joomla Password
How do I reset my Joomla password?
Knowledgebase Article 221,212 views tags: joomla password

How to Reset Your Login Password
How do I change my Control Panel password?
Knowledgebase Article 1,715,363 views tags: change cpanel password passwords protect

Password Types
This article explains the different password types for your hostmonster account.
Knowledgebase Article 234,005 views tags: billing cpanel hosting main password

Resetting the Password for an Email Account
Instructions for restting your Email Account's Password through cPanel or Webmail
Knowledgebase Article 607,322 views tags: email forgot password reset webmail

How To Find Your WordPress Database
This article explains how to find the database in use by a WordPress site.
Knowledgebase Article 329,979 views tags: database find wordpress

How To Disable Or Delete Plugins / Themes On A Disabled WordPress Site
This article explains how to deactivate, change or delete themes and plugins on a WordPress site without the dashboard.
Knowledgebase Article 294,154 views tags: access dashboard deactivate disable plugin plugins theme themes wordpress

This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here