Hi Fred,
I got connect to mysql as a root user at localhost and I want to switch
the user to user1 at localhost.
I have used mysql_connect() and also mysql_real_connect().
The commands I have used at mysql> prompt and the corresponding errors are
given below :
[sbhamidi@darkness bin]$ ./mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.22.19
Type 'help' for help.
mysql>
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
Mysql> mysql _connect(host localhost,user user1,passwd);
ERROR 1064: You have an error in your SQL syntax near 'mysql_connect(host
localhost,user user1,passwd)' at line 1
If I am wrong in supplying the arguments please help me.
Thanks.
Srini
-----Original Message-----
From: Fred Lindberg [mailto:lindberg@stripped]
Sent: Friday, April 09, 1999 9:52 AM
To: mysql@stripped
Subject: Re: How to switch users.
On Fri, 9 Apr 1999 09:51:13 -0500, Srini Bhamidipaty wrote:
>I have gone through the manual and I could find only how to connect from a
>shell prompt.
Where _do_ you want to connect from?
mysql_connect() takes a user arg (as well as the DBD/DBI functions),
mysql from the command line takes -u user, ODBC takes a user argument
...
-Sincerely, Fred
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread1587@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
