How to reset Magento Admin Password

To change your Magento admin password use the below query,

UPDATE admin_user SET password=CONCAT(MD5('mynewpass'), ':sG') WHERE username='AdminUsername';

Note: You should know your username.