This is one of the proposed solutions found in the article Jacob mentioned, and it worked great as a manual way to change the password without having to use the email reset.
In the DB table wp_users, add a key, like abc123 to the
user_activation column.