admin password reset in phpmyadmin, how to?

[Hagaman]

UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = X

...with 'X' being your userid number and <prefix> being your table prefix.
-------------
for example:

UPDATE forums_user SET PASSWORD = MD5( CONCAT( MD5( 'jacklee' ) , salt ) ) WHERE userid =1