[thelist] PHP to mySQL connect...

jsWalter jsWalter at torres.ws
Fri Jul 23 21:30:25 CDT 2004

I have 2 machines, a server (Win NT server) and a workstation (Win XP

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    = "";
   $db_name    = "myDB";
   $db_host    = 'db.torres.ws';  // ''

   mysql_pconnect($db_host, $db_user, $db_pass)
      or die("Unable to connect to SQL server");

      or die("Unable to select database");

I get this...

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

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

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

Anyone have any ideas?



More information about the thelist mailing list