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?