I just had a great time not being able to log into mysql after I attempted to reinstall, due to some problems that I had with my environment. Oh, was that fun. Fortunately, I found this article with detailed information:
http://lstigile.wordpress.com/2009/06/15/mysql-windows-install-troublesh...
CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost';
FLUSH PRIVILEGES;
I often forget this, so....
MySQL autoincrement == IDENTITY(1,1) as in
id int IDENTITY(1,1) PRIMARY KEY,