Zend Anwar

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.