PHP to mySQL connect...
| From: | \[php\]Walter | Date: | Sat, 24 Jul 2004 02:30:31 +0000 |
| Subject: | PHP to mySQL connect... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-24260@lists.php.net to get a copy of this message | ||
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 = "";
$db_name = "myDB";
$db_host = 'db.torres.ws'; // '192.168.1.10'
mysql_pconnect($db_host, $db_user, $db_pass)
or die("Unable to connect to SQL server");
mysql_select_db($db_name)
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 works.
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?
Thanks
Walter