The SQL command syntax to do this in phpMyAdmin is:
UPDATE users SET pass = md5('new_password') WHERE uid = 1
UPDATE users SET pass = md5('new_password') WHERE uid = 1