From owner-freebsd-database@FreeBSD.ORG Tue May 13 06:44:27 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 735BB37B401 for ; Tue, 13 May 2003 06:44:27 -0700 (PDT) Received: from mailhub5.isdnet.net (mailhub5.isdnet.net [195.154.209.25]) by mx1.FreeBSD.org (Postfix) with ESMTP id 07B3643F85 for ; Tue, 13 May 2003 06:44:26 -0700 (PDT) (envelope-from anselme@netcourrier.com) Received: from [192.168.1.113] (ppp1494-cwdsl.fr.cw.net [62.210.117.217]) by mailhub5.isdnet.net (8.9.3p2/8.9.3) with ESMTP id PAA48303 for ; Tue, 13 May 2003 15:44:24 +0200 (CEST) From: Anselme To: freebsd-database In-Reply-To: <1052813583.268.18.camel@Toto.dippgw.homedns.org> References: <1052813583.268.18.camel@Toto.dippgw.homedns.org> Content-Type: text/plain Organization: Message-Id: <1052833369.268.30.camel@Toto.dippgw.homedns.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 13 May 2003 15:42:49 +0200 Content-Transfer-Encoding: 7bit Subject: Re: MySQL & jdbc -Got it ! 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: Tue, 13 May 2003 13:44:27 -0000 > On Tue, 2003-05-13 at 08:26, Tom Samplonius wrote: > > > > > And "user" isn't the only access table. There is a table for hosts, and > > as well as databases. The MySQL permissions system is very complicated. > > > You were right !! I kept 127.0.0.1 localhost.mydomain.com localhost in /etc/hosts. BUT in the database mysql I've change like this : mysql> select host, user from user where user="anselme" ; +-----------------------+-----------+ | host | user | +-----------------------+-----------+ | localhost.mydomain.com | anselme | +-----------------------+-----------+ 1 row in set (0.01 sec) AND (very important) mysql> select host, user from tables_priv where user="anselme" ; +-----------------------+-----------+ | host | user | +-----------------------+-----------+ | localhost.mydomain.com| anselme | +-----------------------+-----------+ 1 rows in set (0.00 sec) Now, it works !! I don't think there is any problem doing like this ? Thank you very much everybody for your help :)) -- Anselme