Phil Tomson wrote:
> 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
> 
> 
> 
> 

Phil

	First, to create a database with the cli for mysql, type this at the 
command line:

mysql> create database <name>.

	Second - unfortunatly the CLI for mysql is a little dumb about where it 
puts it's help imho. When you are looking for help about SQL or pretty 
much any server side mysql stuff, start by typing

mysql> help contents

just typing help lists commands that the cli takes, not the db.