Resetting a lost WordPress password

This blog has been lying vacant for a few months now, so I've clean forgotten the username and password. That means I cannot use the password retrieval feature too. Thankfully this post got me in again.

UPDATE wp_users SET user_pass=md5('new_password') WHERE user_login='admin';