Date: 13 May 2003 15:42:49 +0200 From: Anselme <anselme@netcourrier.com> To: freebsd-database <freebsd-database@freebsd.org> Subject: Re: MySQL & jdbc -Got it ! Message-ID: <1052833369.268.30.camel@Toto.dippgw.homedns.org> In-Reply-To: <1052813583.268.18.camel@Toto.dippgw.homedns.org> References: <Pine.BSF.4.05.10305122324510.2996-100000@misery.sdf.com> <1052813583.268.18.camel@Toto.dippgw.homedns.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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 <anselme@netcourrier.com>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1052833369.268.30.camel>