List:General Discussion« Previous MessageNext Message »
From:kalle volkov Date:March 18 1999 9:17am
Subject:Re: Need help with insert user values
View as plain text  
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
Thread
Need help with insert user valuesRobert D. Lang CEO18 Mar
  • Re: Need help with insert user valueskalle volkov18 Mar
  • Re: Problems with synchronisation master -> slaveDominik Klein20 Jul
Re: Need help with insert user valuesEd Carp18 Mar