Skip site navigation (1)Skip section navigation (2)
Date:      12 May 2003 12:46:59 +0200
From:      Anselme <anselme@netcourrier.com>
To:        freebsd-database <freebsd-database@freebsd.org>
Subject:   MySQL & jdbc
Message-ID:  <1052736418.280.23.camel@Toto.dippgw.homedns.org>

next in thread | raw e-mail | index | archive | help
Hi everybody !

I've got a little problem trying to get access to MySQL with a java
application.

I use :
mysql 3.23.55
linux-sun-jdk1.3.1.07_1
mysql-jdbc-mm
FreeBSD 4.7-STABLE

I got the connection with MySQL vi jdbc without problem but i can't
access the database as the user  ...
I got the following from the server :

#java.sql.SQLException: Invalid authorization specification: Access
denied for user: 'user_name@localhost.mydomain.com' (Using password:
YES)


The rights in MySQL sounds good because when I try to access by the
console, it's all fine.

In the java program, I have the following code :
 dbcxn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name?user=user_name&password=user_pwd")

I also tryed with :
dbcxn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/db_name","user_name","user_pwd");

Any Ideas ?

Thanks 

-- 
Anselme <anselme@netcourrier.com>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1052736418.280.23.camel>