From owner-freebsd-database@FreeBSD.ORG  Mon May 12 03:48:42 2003
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6730437B401
	for <freebsd-database@freebsd.org>;
	Mon, 12 May 2003 03:48:42 -0700 (PDT)
Received: from mailhub1.isdnet.net (mailhub1.isdnet.net [195.154.209.21])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 187C843FAF
	for <freebsd-database@freebsd.org>;
	Mon, 12 May 2003 03:48:41 -0700 (PDT)
	(envelope-from anselme@netcourrier.com)
Received: from [192.168.1.113] (ppp1640-cwdsl.fr.cw.net [62.210.118.109])
	by mailhub1.isdnet.net (8.9.3p2/8.9.3) with ESMTP id MAA56261
	for <freebsd-database@freebsd.org>;
	Mon, 12 May 2003 12:48:38 +0200 (CEST)
From: Anselme <anselme@netcourrier.com>
To: freebsd-database <freebsd-database@freebsd.org>
Content-Type: text/plain
Organization: 
Message-Id: <1052736418.280.23.camel@Toto.dippgw.homedns.org>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.4 
Date: 12 May 2003 12:46:59 +0200
Content-Transfer-Encoding: 7bit
Subject: MySQL & jdbc
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 12 May 2003 10:48:42 -0000

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>