How to recover lost password

f you can still remember your username and email address, you can use the Wordpress automatic remailer or “lost password” feature found on your blog’s the login page.

* Go to your Wordpress Login page (http://yoursite.com/wp-login.php)
* Click on Lost you password?
* You will be redirected to a different page where you will be asked to enter your user name or email address.
* Check your email inbox for your new password.
* Login to your Wordpress blog with your new password.
* Go to Profile in your Admin panel and change the password to something that you can remember.

The problem with this feature is that it doesn’t work all the time, especially if the internal PHP mail function is disabled by your web host. I’ve had several experiences where I used that option and I never received the email.

Or

1. Open phpMyAdmin.
2. Click on the drop down menu and select your Wordpress database.
phpMyAdmin

3. From the list of tables, look for the wp_users table and click on the Browse icon. (the prefix may defer with different databases)
phpMyAdmin

4. Click on the Edit icon (pen icon).
phpMyAdmin

5. Look for the md5 hash of user_pass under the Value column.
phpMyAdmin

6. Change the md5 hash with the one you created earlier. If you want to use a different username, you may also change the present value with a new one.
7. Close phpMyAdmin
8. Login to your Wordpress blog with your new password (and username if you changed it).

I hope this series would provide you with the needed information when you experience this issue. Some of you might know a totally different way of doing this. Suggestions and corrections would be greatly appreciated.