mysql : my first table

I'm self-learning (crash course style) about mysql and
it looks like I have mysql running:

//-------------------------------Terminal---------------------------------

[D-Ms-Computer:/usr/local/mysql] mysql1# sudo ./bin/mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data

//----------------------------end Terminal--------------------------------------

My goal now is to create my first table.
My goal is modest, I would be happy if I can just create a
one row- one heading table : ) for now.

The command I entered doesn't seem to be doing the job.
I closed my terminal window, went to take a break and then I tried this:

//-------------------------------Terminal---------------------------------

[D-Ms-Computer:/usr/local/mysql] mysql1# sudo ./bin/mysqld_safe
A mysqld process already exists

[D-Ms-Computer:/usr/local/mysql] mysql1# CREATE DATABASE accounting;
CREATE: Command not found.

//----------------------------end Terminal--------------------------------------

I'm REALLY new to the command line so, I'm a bit puzzled -- any ideas?

Thank you in advanced for your help.

dmonk

That seems right to me. But you need to be in the MySQL client to work with it. You don't just enter those commands in the shell. Try running mysql, and then you should get a mysql> prompt. From there you can run your sql commands.

To run mysql, just enter "mysql" into the shell prompt. Without the "'s of course. You might need to authenticate yourself before you can create databases though. From what I just looked at, it defaults to the user you created mysql with, I think. So you might be ok. But that is something you should look into.

Thank You

Thanks Emrys for the support.

It took me a couple of days but I got mysql client running and I created a quick table. Goal acomplished (for now) Now's time for a break! : )

Emrys said:

To run mysql, just enter "mysql" into the shell prompt. Without the "'s of course. You might need to authenticate yourself before you can create databases though. From what I just looked at, it defaults to the user you created mysql with, I think. So you might be ok. But that is something you should look into.

Click to expand...