How to update password from Database for Magento

Magento

Update Password from admin panel by running following query 

UPDATE admin_user SET password = md5(‘YOUR_NEW_SELECTED_PASSWORD’), is_active = 1 WHERE username = ‘admin’;

YOUR_NEW_SELECTED_PASSWORD will be your new password

Username will be the name of user for which you want to change Password

-->