From: ptkwt@... (Phil Tomson)
Date: 2005-04-08T07:34:42+09:00
Subject: Re: "Rolling with Ruby" for Linux?

In article <139069fcdf21b1849ddfd7e0d20b85d0@grayproductions.net>,
James Edward Gray II  <james@grayproductions.net> wrote:
>On Apr 7, 2005, at 3:59 PM, Phil Tomson wrote:
>
>> I'm wondering if anyone has modified Curt's tutorial for use on Linux?
>
>Have you tried the command-line client installed with MySQL?
>
>$ mysql -u username -p
>
>See if that gets you anywhere.
>

OK, that seems to be better. I get:

  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 2 to server version: 4.1.11-standard

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

  mysql>


I've got to admit I've never used any kind of database before (hey, I've 
hashes right? :).  So I'm getting the idea that 'root' in this case (the 
username I used above in the mysql command) is not the same as root on my 
system - correct?

Also, now that I've got this mysql> commandline, I'm not quite sure what 
to do next.  Curt's tutorial talks about creating a new database called 
'cookbook'.  'help' doesn't reveal a 'new' or 'add' command.  I tried 
'use cookbook' but of course it replies that it doesn't know about a 
database called 'cookbook'.

Phil