I have my own Wordpress installation for my infrequently updated blog.
I have a habit of forgetting my password so have to request a new one and reset it every two to three months.
I've done it again today and got the "Password Reset" e-mail (which arrives within seconds of requesting it). Following the link to actually reset the password gives me the "Check your e-mail for your new password." page but that e-mail never arrives.
I've checked my spam folder and there's nothing in that.
What's the quickest way of resetting my password and getting back into my blog? Do I have to go via the database? If so what do I need to reset there?
I should add that the blog hasn't been hacked - I've checked the pages and they're all OK. No spurious links or content vandalised.