Reset admin password with no mail server

[scouser82]

Hello,

I've fubard my database because I thought I could paste a MD5 has over the password I've forgotten which didn't work.

I think I can do a fresh install and then copy the table over to the old install to get a password.

I really don't want to have to install a SMTP server, any ideas of how to reset.

Scouse82

 

[scouser82]

Found the answer:

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

S82