On Tue, 7 May 2002, George Pitcher wrote:
> Date: Tue, 7 May 2002 06:15:28 +0100
> From: George Pitcher <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: JDBC connection to MySQL
>
> Just a guess, but how about an ampersand?
>
> Connection c =
> DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username&pas
> sword=password");
Well this is what I use..
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
where DBUrl = "jdbc:mysql://localhost:3306/"+"database_name";
and dbuser = "StringofPermittedUser"
and dbpasswd = "StringofCleartextPasswordforUser"
>
>
> George
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, May 07, 2002 5:11 AM
> Subject: JDBC connection to MySQL
>
>
> > Hello,
> > I've been struggling with this for two weeks, I can't seem to find the
> answer
> > wherever I look whether in the core mysql book or the documentation on
> what
> > variables, if any go between parameters(user and password) as in:
> > Connection c =
> > DriverManager.getConnection("jdbc:mysql://localhost/dbName?user=username,
> > password=password");
> > what goes between the user parameter and the password parameter( a comma?
> a
> > space? no space?).
> > I presume since the mm.mysql driver (org.gjt.....) is under the servlet
> > directory and the servlets are working I don't need to set the classpath
> to
> > the driver(i.e already set to the parent, servlet directory). Thanks in
> > advance.
> > Patrick
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
