Ralf Mler wrote: > Am Mittwoch, 28. Juli 2004 08:43 schrieb Ralf Mler: > >>Am Dienstag, 27. Juli 2004 18:56 schrieb Lennon Day-Reynolds: >> >>>Ralf, >>> >>>I know that the MySQL hostname-based authentication always gives me >>>problems. I think you need to make sure that you have access rules for >>>'ram@localhost', as well as just 'ram', otherwise connections coming >>>in over a TCP socket (which DBI uses) will be handled differently than >>>those coming in over the mysqld domain socket (which the command-line >>>client uses by default). >> >>Moin Lennon, >> >>I'm not sure, how to do that. >> >>Passing >> >>grant all on lcwa.* to ram identified by 'lcwa'; >> >>to the mysql-client did not succeed. the DBI-Statement lead to the same >>results. > > > 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 Hm, localhost=127.0.0.1 and lilith=192.168.1.xx (or something alike), then it should not work. Regards, Michael