MySQL & jdbc

[Roberto Nunnari]

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 at 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========================