select UserId, Email, CreateDate
from aspnet_Membership 
order by CreateDate

-- Replace "host@host.com" by the correct email address of the host account

update aspnet_Membership 
set Password='hostpass', 
    PasswordFormat=0 where Email = 'host@host.com'