Magento password recovery / Magento password reset

$pass = "12345678";

$salt = "at";

echo md5($salt.$pass).":".$salt;

 

 

UPDATE admin_user SET password=CONCAT(MD5('gD1qaz2wsx'), ':gD') WHERE username='admin';

 

Here gD is salt