So you can’t login to your admin area- not as stupid as it sounds, of course if you have literally just forgotten your password then maybe you are silly but how this can happen is that you forgot your password and then decided to use the recover/reset option which will change the password in the wordpress database but then for what ever reason the new password is not emailed to you- so you still are no better off because you still don’t know the password so therefore can’t login- yes you could scream!!!!
But wait help is at hand.
Option 1: Steven has written a couple of scripts that as long as you have ftp access to your blog then you can upload his scripts and use it to reset the password or user name. BUT read carefully his disclaimer below and remember buyer beware 
Steven’s comment
Hey Urshula, here’s those 2 scripts I was telling you about:
change_wp_username.zip.
reset_wp_password.zip.As advertised it’s not a good idea to leave them up on a server!
I’ve made sure the textboxes are protected against MySQL injections and stuff like that, though if your password has a single or double quotes in it, or any backslashes you may have some problems. Though who uses those characters in a password… honestly!
Option 2: This is another one from Village-idiot.org which does the same thing and works well. Luckily haven’t used it lately But last time I used it worked a treat.
Option 3: Now I’m going to seem like the silly one but I’ve also reset me password directly through the database so if you have access to your database this to can be an option. This site has print screens to help you through this option