From owner-freebsd-database@FreeBSD.ORG Mon May 12 09:13:21 2003 Return-Path: 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 E9B8A37B401 for ; Mon, 12 May 2003 09:13:20 -0700 (PDT) Received: from mailhub10.isdnet.net (mailhub10.isdnet.net [195.154.209.131]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8776C43FB1 for ; Mon, 12 May 2003 09:13:17 -0700 (PDT) (envelope-from anselme@netcourrier.com) Received: from [192.168.1.113] (ppp1640-cwdsl.fr.cw.net [62.210.118.109]) by mailhub10.isdnet.net (8.9.3p2/8.9.3) with ESMTP id SAA45783; Mon, 12 May 2003 18:13:03 +0200 (CEST) From: Anselme To: Tom Samplonius In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1052755886.1898.7.camel@Toto.dippgw.homedns.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 12 May 2003 18:11:26 +0200 Content-Transfer-Encoding: 7bit cc: freebsd-database 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 12 May 2003 16:13:21 -0000 On Mon, 2003-05-12 at 16:17, Tom Samplonius wrote: > 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 > > Yes, I found some things like that in my research on the web and I guess that's the point, but how can I deal with it ? Because even if in the table 'user' I put : mysql> select * from user where user="user_name" \G *************************** 1. row *************************** Host: localhost.mydomain.com User: user_name Password: 656b45b307f18ae4 Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N 1 row in set (0.00 sec) it doesnot work :(( (I have done the "flush privileges") ??? -- Anselme