Date: Mon, 12 May 2003 18:32:26 +0200 From: Roberto Nunnari <nunnari@die.supsi.ch> To: Anselme <anselme@netcourrier.com> Cc: freebsd-database <freebsd-database@freebsd.org> Subject: Re: MySQL & jdbc Message-ID: <3EBFCC9A.2060209@die.supsi.ch> References: <Pine.BSF.4.05.10305120714480.2996-100000@misery.sdf.com> <1052755886.1898.7.camel@Toto.dippgw.homedns.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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========================
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3EBFCC9A.2060209>