How to reset password in Wordpress

If in case your admin password is not working, you need to reset the password. Here is how you reset password from the database for wordpress.

1.Login to phpmyadmin.
2.Click 'databases'
3.A list of your databases will appear. Click the one that is your WordPress database.
All the tables in your database will appear.
4.Click on the small icon indicated. Hovering this icon should show the word 'browse'.
The next screen will show who is registered on your blog.

You need to look at the top line there. User ID #1 is you - the blog owner. You will see your login name, then a long string of letters and numbers. That's your password.

5.Now you see all the details associated with that user.
Across from the 'user_pass' is your encoded password.

6.Delete that long string of characters.
Now type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
In this example, my new password will be 'carrots' (1)
Once you have done that, click the dropdown menu indicated, and select MD5 from the menu. (2)

7.All good ? Click the 'Go' button to the bottom right.

To reset the password from backend:

UPDATE `databasename`.`tablename` SET `password` = MD5( 'newpass' ) WHERE `tablename`.`id` =62 LIMIT 1 ;

instead of id we can give any other details also.