[iStudent 2003]

I have mySQL installed and running on 10.2.6. I enter in the Terminal

mysql> -h 127.0.0.1 –u root –p password

And it doesn’t let me login, all I get is -> on a new line. I enter it again and it doesn’t work.

I have CocoaMySQL, installed too, and my ip, login and password all work, but I want to be able to use MySQL in the Terminal for learning the SQL commands.

Does anyone know to fix this?

[philzilla]

err, if you're entering that at the mysql prompt, as your post seemed to indicate, then you're already in. you only enter that line from a normal shell prompt. should look something like this:

mysql -h localhost -u root -p <return>
<enter password>
mysql>_

that last line would've looked boss with the blink tag on that cursor.

[insha]

In addition to what phil said; you have to end all sql commands with a semicolon ( once you are in mysql using the Terminal.

To recap do the following:

[you prompt] user% mysql -h localhost -u root -p <return>
Enter Password: <type password and press return>

You should now be in MySQL monitor; the prompt should be:

mysql>

Once you're there type select a database start learning:

SQL Commands (note the semicolon):

Select Database = use <database name>;
List all DB = show database;
etc.

Hope this helps.