On Fri, 12 Nov 1999, Hoepner, Jim R. wrote:
> I have not been successful at inserting a new user - with password - into
> the mysql DB's "user" table. Here's what I tried:
> ----------------------------------------------------------------------
> c:\mysql\bin\mysql -uroot mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.21.29a-gamma-debug.
> Type 'help' for help.
>
> mysql> insert into user(Host,User,Password)
> values('localhost','myuser',password(mypasswd));
> ERROR 1064: parse error near 'user(Host,User,Password)
> values('localhost','myuser',password(mypasswd))' near line 1
> mysql>
> ----------------------------------------------------------------------
>
> Can you please tell me what I'm doing wrong?
> Thanks!
Sure. You've omitted the quotes which you need around 'mypasswd'.
Also, try inserting a space after 'into user' and 'values' (bug in MySQL
parser, fixed in 3.23).
--
Bob Kline
mailto:bkline@stripped
http://www.rksystems.com
