Magento reset Admin Password

It is very simple

 

UPDATE admin_user SET password=CONCAT(MD5(‘ShAfInAnWaR’), ‘:sG’) WHERE username=’Adminusername’;

 

Note: You have to change newpass in the MD5(‘ShAfInAnWaR’) with your new password, and change *Adminusername* to your Magento admin username.