reset the Admin Login and password in Vbulletin 4

f you really want to set your password to NEWPASSWORD, the resulting query would be:

UPDATE user
set password = MD5(concat(MD5('NEWPASSWORD'), user.salt))
WHERE userid = 1

The best place to use this query in phpMyAdmin would be the SQL tab.