Resetting MySQL password on Win 7

1. You MUST (ie. MUST MUST MUST MUST MUST) start the command prompt with "Run as Administrator"!

2. Then you can follow the instructions at:

http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

If you do not start as Administrator, your "user" (even if he has Administrator rights) will not be able to access MySQL binary and data path. It will create a new instance of the database somewhere in

C:\Users\MySuperDuperUselessAdminUser\AppData\Local\VirtualStore\ProgramData\MySQL\blah blah blah...

And this is wrong. Even if you reset the password here, when you start the actual instance via Windows Service, it will go back to the actual datastore location and you will still fail to login.

Yes, it took me 1hour+ to get this sorted out. Hope this saves someone some pain.

GRR...