Locked out of my own blog and password reset not working

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.

If you can get to phpMyAdmin (or something equivalent), open the DB and find the wp_users table. Select the appropriate user to edit and change the user_pass field to whatever. Set the function to MD5 and save. You should now be able to log in.