[Lynne]

Did you change your domain (and perhaps your cookies are set incorrectly)?

And wait a sec.... you are posting in the vB5 section, so I gave you the vb5 query.

If you really mean vB4, and not vB5, then use this query to change the password:

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

The above will reset the password of user with userid = 1 to pass1234. Change the userid if your Admin account is not userid 1.