Simple way,
update user set email='youremail' WHERE username='username';
Then use the forgot password link. OR you can just update his password with,
select salt from user WHERE username='username';
You should have a random salt now something like A2A
Just md5 your password, then md5 your password with the salt on the end.
I created a php script you can use,
<?
$pass = "mynewpass";
$salt = "A2A";
//do not edit here
$newpass = md5($pass);
$newpass = md5($newpass.$salt);
echo $newpass;
?>
Then you can just
update user set password='thepassoutputed' WHERE username='username';
Hope that helped
-Scott