If you already have email/smtp configured and working you could edit the email to be your email and then use the password recovery.

Otherwise you have to go into the mp_Sites table and change the password format to 0, then you can edit the poassword directly in the db as plain text.

Then recycle the app to clear the cache.

Hope it helps,

Joe 

after making the changes in the db you have to clear the cache, otherwise its still using the cached copy of site settings. Either recycle the app pool or touch the Web.config (ie type a space in it) to clear the cache.

password recovery uses the smtp settings from the system.net.mailsettings section of web.config

Hope it helps,

Joe 

make sure you set the passwordformat to 0 in mp_SiteSettings

make sure you set IsLockedOut = 0 or false and FailedPasswordAttemptCount = 0 in mp_Users

edit the password in mp_Users to "admin"

recycle the application pool

login, it should work or you are not following all the steps

This problem comes up often enough that I decided to write a little article to help, see Oops You Forgot the Admin Password.

Hope that helps,

Joe