On Fri, 9 Apr 1999 10:49:20 -0500, Srini Bhamidipaty wrote:
>Mysql> mysql_real_connect(host localhost,user user1,passwd);
>ERROR 1064: You have an error in your SQL syntax near
>'mysql_real_connect(host localhost,user mali,passwd)' at line 1
These are C API commands, not usable in the mysql client. They are
functions you use from within a C program to connect to a server.
As far as I know, you cannot switch identity at the mysql> prompt. Quit
mysql, and start it again:
% mysql -u user1 -p
Yes, you have to define "user1" in the grant tables. You need to read
the manual for info on how to set up new users. The manual is included
in the distribution and available on line via the link below.
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)