How to reset the admin username and password for a WordPress blog

More work on the WordPress blog (see previous post). I realized that my permissions were read-only. This article helps; the trick is to edit the user on the wp_users table of the database, ensuring that you choose MD5 as the function to run on the password field, otherwise it won't be encrypted. Though the article covers an older version of MySQL, it's still applicable.