From owner-freebsd-database@FreeBSD.ORG Tue May 13 01:14:50 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 15E7137B404 for ; Tue, 13 May 2003 01:14:50 -0700 (PDT) Received: from mailhub1.isdnet.net (mailhub1.isdnet.net [195.154.209.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9F85243F3F for ; Tue, 13 May 2003 01:14:48 -0700 (PDT) (envelope-from anselme@netcourrier.com) Received: from [192.168.1.113] (ppp1494-cwdsl.fr.cw.net [62.210.117.217]) by mailhub1.isdnet.net (8.9.3p2/8.9.3) with ESMTP id KAA42446; Tue, 13 May 2003 10:14:40 +0200 (CEST) From: Anselme To: Tom Samplonius In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1052813583.268.18.camel@Toto.dippgw.homedns.org> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 13 May 2003 10:13:03 +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: Tue, 13 May 2003 08:14:50 -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. > Yes, but when I run MySQL on the console with this user and this password, I have no problem. This user has restrected access to a specific database and only on some tables from this database but it works fine ... except when I try from the java program, still get this Invalid authorization specification: Access denied for user: 'anselme@localhost.mydomaine.com' (Using password: YES) !*$?!!%! > Tom -- Anselme