Forgot Drupal Login Password; How to Reset Drupal Login Account Password?

Problem:
How to Reset Drupal Login Account Password (as you forgot)?

Solution:
Execute the following query on the Drupal database to reset the drupal:

UPDATE users SET pass=MD5('new_password') WHERE uid=1; 

• new_password -> is your new password 
• uid=1 -> denotes that you are changing the password for the admin/administrator user

Note: uid can be of any valid user drupal id.