Info
Steps
expand wp_YOURINSTALL
expand wp_users
find the user in the list, select edit
select MD5 from the user_pass function dropdown
enter a new password in the user_pass value
push Go to save changes
you can now use the new password to login to your install