Go into C:/mysql/bin .. and look for a file called Winmysqladmin

Open it and it will move to the system tray. Open it and edit the my.ini file... to reflect the change. Alternatively.. look in the C:/windows directory for the file and edit it in notepad/wordpad.

A useful tip after you have done this.. reboot the machine and then... when you need to access mysql.. use the -p flag.. but without putting in your password.. so it looks like this..

mysql -uroot -p

It will then ask you for the password

Here is how I setup MySQL... for future reference..

1) Install MySQL
2) Open a DOS window and navigate to C:/mysql/bin
3) Type : mysql -uroot
4) The prompt will change to say mysql>
5) Type set password for root@localhost = password ('password');
6) Exit

Then when you create your db's.. do this..

1) Dos window... and navigate to c:/mysql/bin
2) Type mysql -uroot -p
3) enter password
4) At mysql> prompt type : create database new;
5) Grant all priveleges on new.* to newuser@localhost;
6) set password for newuser@localhost = password ('password');
7) Exit

That creates a db called "new" (or whatever you would prefer).. creates a user with all privileges called "newuser" who can only access the "new" db. It also sets a password.

Edit... btw.. the ('password') is what you want it to be.. eg... ('clutch') or ('sqlisgreatbutconfusing')

This whole process enables a recommended security tip. Avoid using root as a default user as much as possible