how to change admin password from database in magento

If you forget your admin password you want to reset  magento admin password through PhpMyAdmin . Now you simply need to know what is suffix your magento password is using . Just see the current encrypted password by SELECT * FROM admin_user; suppose your password value is “e53f3a2b9372babb593ed61c119c5ee1:El” then your suffix is El (i.e., last(…)