Jon Raphaelson
4/8/2005 4:16:00 AM
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.