If you ever lost your WordPress admin password for any reason and you can’t logon to your administrator panel again and don’t know what to do, here is a short simple yet powerful solution instead of deleting all your wordpress files from your server and reinstalling it all over again:

1. From your webhost control panel (usually CPanel) logon to your phpMyAdmin.

 

2. Click Databases.

 

3. If you already have multiple databases, choose the database that is associated with your wordpress blog, It will usually have your username and wordpress prefix on it’s name depending on what you have choosed first time when creating the database.

 

4. After you select the correct database, you will see a table with a list of rows and columns, from the row with the name wp_users click right above the small icon that says browse when you hover your mouse pointer over it.

 

5. On the new screen, you will see a list of rows which represents the registered users on your wordpress blog, the blog admin should usually have ID #1  along with login name (user_login) and password (user_pass) in the form of a long string of numbers and letters (this is your old admin password encrypted in the database) . Now we need to edit that password field so we can create a new one for our wordpress admin control panel. to do this, we need to click on the pencil icon on the far left beside the empty check box.

 

6. On the next screen you will see a box contains all the user details, on front of the user_pass field delete the long string of encoded characters, and then type the new password you want normally in the same field. here we will type for example “my new password”

 

7. On the same user_pass row under Function from the drop down menu select MD5. this is the type of encoding of the new password.

 

8. Make sure you have the correct encoding MD5. 

 

9. Now click Go at the bottom of the box.

 

10. Now go to your wordpress admin login page, for example: http://www.mydomain.com/blog/wp-login.php and type in your new password along with your admin username.

 

11. you are inside your WordPress administrator panel and All done.

 

Hope this helps,

any comments, suggestions or ideas are very welcome.

keywords used:

wordpress, admin, password, lost, recover, how to, database, phpmyadmin, cpanel, md5, username, blog, solution, fix,  word press, host, hash, edit, administrator, login.