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" error | phpWalter | 24 Jul |