From: kalle volkov
Date: March 18 1999 9:17am
Subject: Re: Need help with insert user values
List-Archive: http://lists.mysql.com/mysql/472
Message-Id: <36F0C4A5.2572@tank.ee>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

hi!

u have to first select database u want to insert into...

like:
---
# bin/mysql mysql
mysql> insert into user ... ;
---
or:
---
# bin/mysql
mysql> use mysql
mysql> insert into user ... ;
---

regs,
cal6



Robert D. Lang CEO wrote:
> 
> Dear Mysql Users:  I need help with the command line for inserting user
> values to the mysql database, user table.
> I have typed the below and as you can see from the telnet log, I have
> failed. (I have initiated the mysql monitor first of course).
> 
> Can someone please tell me what I am doing wrong here and what the
> correct command is?
> 
> mysql> insert into user values ('localhost', 'nobody', '',
> 'Y','Y','Y','Y','N','N','N','N','N','N')\g
> ERROR 1046: No Database Selected
> 
> mysql> mysql
>     -> insert into user values ('localhost', 'nobody', '',
> Y,'Y','Y','Y','N','N','N','N','N','N')\g
> ERROR 1064: parse error near 'mysql
> insert into user values ('localhost', 'nobody', '',
> 'Y','Y','Y','Y','N','N' at line 1
> 
> --
> Sincerely, Robert D. Lang
> CEO
> RDL Communications Inc.
> Speak To Us: rdlcom@stripped   See Us: www.rdlcom.com
> 
> 
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread469@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: mysql-help@stripped