List:MySQL on Win32« Previous MessageNext Message »
From:phpWalter Date:July 24 2004 7:17am
Subject:"Unknown MySQL Server Host" error
View as plain text  
I have 2 machines, a server (Win NT server) and a workstation (Win XP
Pro).

On the server I have PHP, mySQL, Apache, Perl, etc.

If I run this command from the prompt...

   G> mysql -h db.torres.ws -u user

It connects fine.

If I do this from PHP...

   $db_user   = "user";
   $db_pass    = "pass";
   $db_name    = "myDB";
   $db_host    = 'db.torres.ws';  // '192.168.1.10'

   mysql_connect($db_host, $db_user, $db_pass)    // <-- line 12
      or die("Could not connect : " . mysql_error());

   mysql_select_db($db_name)
      or die("Query failed : " . mysql_error());

I get this...

    Warning: mysql_connect(): Unknown MySQL Server Host 'db.torres.ws'
            (11001) in G:\home\php\htdocs\db.php on line 12

But if I use the IP or 'localhost', it connects just fine.

BTW: db.torres.ws is in the HOSTS file on both machines.

This worked before. I had to reinstall the database and now it doesn't
work.

Anyone have any ideas?

I would really like to use the machine name again.

Thanks

Walter


Thread
"Unknown MySQL Server Host" errorphpWalter24 Jul