From owner-freebsd-database@FreeBSD.ORG Mon May 12 09:32:54 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 30F0B37B401 for ; Mon, 12 May 2003 09:32:54 -0700 (PDT) Received: from mail.die.supsi.ch (mail.die.supsi.ch [193.5.153.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id BC13043F75 for ; Mon, 12 May 2003 09:32:52 -0700 (PDT) (envelope-from nunnari@die.supsi.ch) Received: from die.supsi.ch (pcm2022.die.supsi.ch [193.5.152.22]) by mail.die.supsi.ch (8.11.6/8.11.6) with ESMTP id h4CGWQY18878; Mon, 12 May 2003 18:32:26 +0200 Message-ID: <3EBFCC9A.2060209@die.supsi.ch> Date: Mon, 12 May 2003 18:32:26 +0200 From: Roberto Nunnari User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Anselme References: <1052755886.1898.7.camel@Toto.dippgw.homedns.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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:32:54 -0000 in my /etc/hosts file I have the following lines regarding localhost: ::1 localhost localhost.my.domain 127.0.0.1 localhost localhost.my.domain and mysql> use mysql mysql> select host, user, password from user; reports:¨ +----------------+------------+------------------+ | host | user | password | +----------------+------------+------------------+ | localhost | salathe | mycryptedpassword | +----------------+------------+------------------+ 11 rows in set (0.02 sec) regards. Anselme wrote: > 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") > > ??? -- Roberto Nunnari -software engineer- mailto:nunnari@die.supsi.ch Scuola Universitaria Professionale della Svizzera Italiana Dipartimento di Informatica e Elettronica http://www.die.supsi.ch SUPSI-DIE Via Cantonale tel: +41-91-6108561 6928 Manno """ fax: +41-91-6108570 Switzerland (o o) =======================oOO==(_)==OOo========================