How to change admin password magento using my sql query

Magento Reset Admin Password

Tested on Magento >=1.4

UPDATE admin_user SET password = MD5("admin123") WHERE username = 'admin'

Take a look at the admin_user table, here you can see the admin users records.

Select the MD5 function to be applied to the password field
Update password field

Now you are able to log in with new password.