Just Host 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.
- The name of your WordPress database. If you aren't sure please see How to find your WordPress Database
- Your Just Host cpanel username and password
Access phpMyAdmin
These steps explain how to access phpMyAdmin.
- From your account cpanel, go to the databases group of icons, and click on phpMyAdmin
- When prompted login with your cpanel username and password.
- 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.
-
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. - Click edit next to the user you want to set the password for.
- Enter the new password into the password box
- In the function box next to the password choose MD5
- Click Go
The password has been reset. You can now login to WordPress with your new password.