List:MySQL on Win32« Previous MessageNext Message »
From:Bob Kline Date:November 12 1999 2:20pm
Subject:Re: Inserting a user(with password) into mysql's "user" table...
View as plain text  
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

Inserting a user(with password) into mysql's "user" table...Jim R. Hoepner12 Nov
  • Re: Inserting a user(with password) into mysql's "user" table...Bob Kline12 Nov