connect to DBD::MYSQL

[fionbarr]

I am trying to connect to MySQL with this code:

my $hostname    = "localhost";
my $db_name     = "test";
my $dsn         = "DBI:mysql:host=$hostname; database=$db_name";

my $dbh         = (DBI->connect($dsn, "ttt", "nancy613",
                    {PrintError => 0, RaiseError => 1} ));

I am getting this error: 'Unknown MYSQL server host ' localhost' <11004>'

[Tux]

1. Please remove your credentials (or replace them with something stupid)
2. Is localhost present in /etc/hosts?

[fionbarr]

thanks....the credentials are already 'stupid'. This is a windows7 machine.

[Tux]

Did you try to replace localhost with 127.0.0.1?

edit (added question): Is the error really 'Unknown MYSQL server host ' localhost' <11004>', as in '<space>localhost? Could it be your code is not actually what you pasted, and the is a space before $hostname?

[Generoso]

Think you are missing the port 3306.

my $port1='3306';
my $host1="localhost";
my $service1="test2";
my $userid1="xxx";
my $passwd1="yyy";
my $connectionInfo1="DBI:mysql:database=$service1:host=$host1:$port1";

[FloydATC]

If MySQL is running on the local machine, there are actually two ways you can connect to it; either via TCP/IP on the localhost address (127.0.0.1) or via a named pipe.

...Ofcourse, this doesn't actually explain the error you're getting, but it may help you bypass it: 4.2.2. Connecting to the MySQL Server

The article seems to suggest you may need to tweak things a bit on Windows to use named pipes on that platform.

[karlgoethebier]

..."...Ofcourse, this doesn't actually explain the error you're getting"

It doesn't, indeed. But perhaps this issue has something to do with avian carriers? I remember you already mentioned this.

Karl