MySQL command line magic

When debugging MySQL (VS 2005) a few helpful command line arguments:
--console ## display server output on a console window (console is nice, debugging services can be painful)
--basdir="C:\MySQL" ## path to root of the DB

I also needed: --skip-grant-tables

Since I forgot the root password to the DB I copied to my dev. box I had to set a new one.
After starting MySQLd.exe with the --skip-grant-tables I took the following steps:

> mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.5-alpha-pro-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> UPDATE mysql.user SET Password=PASSWORD('xxxxx')
-> WHERE User='root';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> quit
Bye

Restart without the --skip-grant-tables option and we are back in business.

It's so cool when things work!