I am trying to enter the program mysql but I keep getting the error

[nikos101]

I am trying to enter the program mysql but I keep getting the message

C:\Documents and Settings\NIKOS>mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N
O)


but it works if I do the following

C:\Documents and Settings\NIKOS> mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

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

How can I set it up so I don't need to enter the password?

[_Aerospace_Eng_]

What did you use to setup mysql in the first place? When you set it up you likely created a password.

[nikos101]

What did you use to setup mysql in the first place? When you set it up you likely created a password.

the microsoft config wizard. I set up the password there. I did this like the book Beginning MySQL by wrox said so in ch 2. However in ch 4 they don't include the password command when explaining the code so I was trying to do what the book said only I had to keep enteringthe passsword to start using the mysql program. How do I change it so that no password is required in the windows version 5.0?

thanks

[guelphdad]

enter the password each time. it is a good habit to get into. if you remove your password entirely then the database can be compromised.

[nikos101]

ok, thanks coders.