In this article I will explain steps to Recover WordPress Admin password at localhost via phpMyAdmin Interface.
Resetting password at live server of WordPress Self hosted blogs/websites are easy.
What if you forget password of a localhost installation?
To reset password at localhost some manual work needed to be done.
On localhost installations WordPress Reset password function don’t send a reset e-mail to your e-mail.Since most default localhost server install has not configured to send a e-mail.
So, How to deal with it?
Follow these steps to recover Lost Password.
1. Log In to phpMyAdmin Panel
Browse to http://localhost/phpmyadmin/ and enter your Mysql user name and password and click on “Go”.
2. Select the database of WordPress installation
Choose the database of WordPress installation which password need to recover.
if you don’t remember database name then go file directory of WordPress install and look for
|
0
1
2
|
define(‘DB_NAME’, ‘wpdir’);
|
in wp-config.php file.In my case database name is ‘wpdir’.
3. Select wp_users Table
In my case prefix is wp_ you may have different prefix. But table name will be yourprefix_users.
Once clicked on users table a list of users will show.Click on ‘Edit’ link of the user whose password you want to reset.
In My case it is ‘Gyanendra’.
4. Change the Password
Once you will click on wp_users table you will see the table structure as show in the picture below.
- a.In user_pass column select md5 in drowdown.
- b. Enter the password of your choice in corresponding value field.
- c. Click on ‘Go’ to save the settings.
Once done browse admin section of your WP website and enter username and password you just changed.
You should be able to Login!
Feel free to comment below or ask question 🙂
