N/APosted on - 09/20/2011
I have a WordPress blog where most of the time I post and edit article and others but suddenly I lost and forget my password so I now I am in very bad situation.
Have any person who can suggest me, how I can recover my password of entering dashboard of WordPress.
How I can recover my password of entering dashboard of WordPress?
The best way to get back your password is through the WordPress database directly. phpMyAdmin tool at your web hosting is the most convenient way to manage the database.
Select the word press database from the drop-down menu list on top after getting into the phpMyAdmin.The page gets refreshed and the tables in the database will be displayed on it. Open the SQL tab and have a look at the top navigation bar
In the text field write the following SQL query:
UPDATE `wp_users` SET `user_pass` = MD5( 'new_password_here' ) WHERE `wp_users`.`user_login` = "admin_username";
"new_password_here" – replace this with the new password you wish to use.
"admin_username" – replace this with the username the password should be updated for.
Once you are ready, click on the GO button to submit the query.
With this you should be able to login to WordPress with the new password.