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!
