how to change admin password on local wordpress install (localhost)

Hi
I have read a lot of posts on changing your localhost wordpress admin password if you forgot or lost it. They all seem to revolve around phpmyadmin, but this is fiddly and sometimes a pain, especially if forgot your phpmyadmin password too or it wants you to ugrade mysql even if it already is.
The easiest way I found to change a forgotten admin password that is installed on a local server (localhost) is to either
1. create a new site locally (webmatrix -> new -> app gallery etc). Remember the password for this and keep the user as the same as the one for the password you lost on your original wordpress site.
or
2. if you have another wordpress site you know the admin password, load that site in webmatrix.

Then in webmatrix, go to Databases then expand tables and open wp_users. Highlight the entire password for ‘admin’ and copy (don’t cut lol).

Now, open the site with the forgotten password in webmatrix. once again, go to databases, tables, wp_users, and where it has “password” for the admin, highlight the password txt and paste in your copied “working password”.

Now you can log in to your wordpress admin console with that password.
Hope this helps