From owner-freebsd-database@FreeBSD.ORG  Mon May 12 08:59:25 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 AB03837B401
	for <freebsd-database@freebsd.org>;
	Mon, 12 May 2003 08:59:25 -0700 (PDT)
Received: from misery.sdf.com (misery.sdf.com [207.200.153.226])
	by mx1.FreeBSD.org (Postfix) with ESMTP id DEEC943F3F
	for <freebsd-database@freebsd.org>;
	Mon, 12 May 2003 08:59:21 -0700 (PDT)	(envelope-from tom@sdf.com)
Received: from tom (helo=localhost)
	by misery.sdf.com with local-esmtp (Exim 2.12 #1)
	id 19FE7L-0002bI-00; Mon, 12 May 2003 07:17:27 -0700
Date: Mon, 12 May 2003 07:17:11 -0700 (PDT)
From: Tom Samplonius <tom@sdf.com>
To: Anselme <anselme@netcourrier.com>
In-Reply-To: <1052736418.280.23.camel@Toto.dippgw.homedns.org>
Message-ID: <Pine.BSF.4.05.10305120714480.2996-100000@misery.sdf.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
cc: freebsd-database <freebsd-database@freebsd.org>
Subject: Re: 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 15:59:25 -0000


  When running mysql on the console, it will connect via a named pipe.
The JDBC driver does not support named pipes, and must open a TCP/IP
socket to localhost.

  A common problem is that the MySQL permission tables say "localhost",
but 127.0.0.1 reverse resolves to "localhost.mydomain.com".  


Tom


On 12 May 2003, Anselme wrote:

> 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>
> 
> _______________________________________________
> freebsd-database@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org"
> 
>