All,

 I'm brand new to dotnetnuke, inheriting a site from a developer who died.  I need to get the superuser password and am having some issues.  I'm in the database and can't find the user with username of "host" with the following:

 select * from aspnet_users where UserName like 'host';

 I found a user that I know the password and salt to copy over, but it seems like there is no superuser account.  Is this possible.  Am I looking in the wrong place?

Thanks,
Eric

I realize the answer is some 5 years old but having slightly different circumstances that this post helped me resolve, I will comment on how it helped.

I think of things too complex ... wanted to recover the host password with the query the new user above (as of 2012) commented on. Could not find it and didn't want the hassle of remoting into a server where I know the query is on the desktop. I know .... lazy, right? Guilty as charged.

I'd already created a user for the recover password query to work against to reset the host password and had actually been in search of where authorizing the user lived in the DNN database. Then stumbled upon Martin's answer.

One can simply SET IsSuperUser = 1 on the new user, even if not authorized. Then log in with that user and Presto! -- the user is automatically now authorized. I was hoping that would happen. Now I just navigated to host | Super User Accounts. For those totally new, just mouse over Host in the Nav bar, select the Settings Icon with the 2 gears in it -- the middle one. This displays the menu that includes Super User Accounts.

in Super User Accounts, edit the other host account password.

This avoids having to run a query at the database level to reset the host password. And where the username of 'host' has been changed, works around not being able to find it in the database.