mysql monitor login error 1

[sd0t1]

I am having trouble logging into to my mysql monitor. Here is my problem.

when I run it from the "start menu" I goes right to asking me for the password to my root account. Any thing other than the password kicks me out.I can log into this just fine. Then I created some new users. Then when I try to login and test the new users I get the below issue.

When I go to my MS command line and type "mysql" I get:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your connection id is 95
Server version:5.0.51b-community-nt-log MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

Then I type "-u root" and hit enter.
all it does is do "->" then I add a semi-colon and I get an error.

Error 1064 (42000): You have an error in your sql syntax;...

I"m not even sure if I'm doing something wrong or if I have a configuration issue.

Please can someone advise as to what I'm doing wrong.

 

[vacunita]

When you type mysql by itself and hit enter it automatically logs you into the mysql command line client using the anonymous login.

From there you cannot pass a user, only valid queries are accepted. If you want to specify a user for logging into the mysql monitor you need to do it from the MS command line.

mysql -u username (all in one line, no enter before the -u or the username)

This will use the given username to log into the mysql client.

If the user has a password then add a -p and the client will request the password after enter has been pressed.

mysql -u username -p








----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[sd0t1]

Vacunita, thanks. That was exactly what I was doing wrong.

The book I'm reading was very clear on how exactly to implement the syntax to login.