RE: MySQL JDBC

["Thomas Michael Koch" <thomask@xxxxxxxx>]

Hey there -

I think maybe you need to attach the port number as well.

In my applications I use the URL:
jdbc:mysql://<hostname>:3306/<databasename>

Insert the correct hostname, databasename and your userId/password.

Hope it works.

Regards
Thomas



-----Original Message-----
From: flag [mailto:flag]On Behalf Of Kenneth Fleck
Sent: 28. juni 2001 12:19
To: mysql list
Subject: MySQL JDBC


Hi !
I have a problem accessing a MySQL DB from a java-app. On commandline I
can get in without problems with

mysql <db> -u<user> -p<pass>

but with the following connect String:

  jdbc:mysql://localhost/<db>?user=<user>&password=<pass>

I get strage result. First time execution error message (from
SQLException caught) is:

  Invalid authorization specification: Keine Zugriffsberechtigung für
Benutzer: '<user>@127.0.0.1'. (Verwendetes Passwort: Ja)

after starting again, the message is :

  Invalid authorization specification: Keine Zugriffsberechtigung für
Benutzer: '<user>@'. (Verwendetes Passwort: Ja)

and it stays like that, the first will come again after not touching the
system for a while.

Has anybody got an idea ?

---
Kenneth

---------------------------------------------------------------------
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 <mysql-thread77904@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-sub-mysql=kapow.dk@xxxxxxxxxxxxxxx>
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 <mysql-thread77908@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php