Ralf Mler wrote:

>Am Mittwoch, 28. Juli 2004 11:01 schrieb Leonid Khachaturov:
>  
>
>>Ralf Mler wrote:
>>    
>>
>>>got it:
>>>
>>>irb(main):003:0>
>>>DBI.connect('DBI:Mysql:database=lcwa;host=lilith;port=6080','ram','lcwa')
>>>
>>>works, but
>>>
>>>irb(main):005:0>
>>>DBI.connect('DBI:Mysql:database=lcwa;host=localhost;port=6080','ram','lcwa
>>>')
>>>
>>>does not. Seems werid to me, cause 'host=localhost' should work, should'nt
>>>it?
>>>      
>>>
>>It depends on security settings. Check out the 'db' and 'host' tables in
>>'mysql' database - if localhost is specified as a host for a database,
>>it means only localhost can connect to it. If '*' is specified, it means
>>"everybody except localhost".
>>    
>>
>
>Hi Leonid,
>
>my 'db' table looks like
>
>+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
>| Host      | Db      | User | Select_priv | Insert_priv | Update_priv | 
>+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
>| %         | test    |      | Y           | Y           | Y           | Y           
>| %         | test\_% |      | Y           | Y           | Y           | Y           
>| localhost | lcwa    | ram  | Y           | Y           | Y           | Y           
>| %         | lcwa    | ram  | Y           | Y           | Y           | Y           
>+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
>
>Does these settings mean, that any host can connect to lcwa?
>
I'm not sure both localhost and % are allowed at the same time... Maybe 
yes, maybe no.

-- 
With best regards,
Leonid Khachaturov
mailto:lenya / chemsell.yaroslavl.ru
web: http://web.yaroslavl.ru/blogs/leonya