From owner-freebsd-database@FreeBSD.ORG  Tue May 13 01:08:20 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 8842A37B401
	for <freebsd-database@freebsd.org>;
	Tue, 13 May 2003 01:08:20 -0700 (PDT)
Received: from misery.sdf.com (misery.sdf.com [207.200.153.226])
	by mx1.FreeBSD.org (Postfix) with ESMTP id F2BB143FA3
	for <freebsd-database@freebsd.org>;
	Tue, 13 May 2003 01:08:18 -0700 (PDT)	(envelope-from tom@sdf.com)
Received: from tom (helo=localhost)
	by misery.sdf.com with local-esmtp (Exim 2.12 #1)
	id 19FTF2-0004Z1-00; Mon, 12 May 2003 23:26:24 -0700
Date: Mon, 12 May 2003 23:26:21 -0700 (PDT)
From: Tom Samplonius <tom@sdf.com>
To: Anselme <anselme@netcourrier.com>
In-Reply-To: <1052812518.268.12.camel@Toto.dippgw.homedns.org>
Message-ID: <Pine.BSF.4.05.10305122324510.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: Tue, 13 May 2003 08:08:20 -0000


On 13 May 2003, Anselme wrote:

> In MySQL, everything is allright :
> 
> mysql> select host, user, password from user where user='anselme' ;
> +-----------+-----------+------------------+
> | host      | user      | password         |
> +-----------+-----------+------------------+
> | localhost | anselme   | 656b45b307f18ae4 |
> +-----------+-----------+------------------+
> 1 row in set (0.00 sec)
...

  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.

Tom