Never got admin new password e-mail

[natem345]

I changed my admin's username, and it said I'd get e-mail with password. Never did. I know I typed e-mail right, as I retyped in send password form--never got one.
So now I need to reset my password without e-mail. I do have FTP access and the database info, and could install phpMyAdmin if needed.
Thanks in advance.

[[Unknown]]

Try setting your "passwd" field in the database to the value you want it to be, but make sure to at least MD5 it with phpMyAdmin.

SMF will automatically upgrade the hashing.

-[Unknown]