RE: [PHP-DB] Remote Connection to Mysql
Also make sure you don't have anything blocking port 3306 like a FW or some IP Filter between the computers. Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 10:26 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Remote Connection to Mysql On Friday 22 March 2002 07:42, Marcus Rigby wrote: > Hi all, > I know there are plenty of remote connection posts herebut none have > helped me solve my problem. > > I have 2 win98 machines on a novell network, both have static IP > addresses, and both machines can ping each other. One machine is > running a webserver and the other the Mysql server, and I cannot get > scripts on the webserver to connect to MySql. > > Using : > $dbcnx = mysql_connect("xxx.xxx.xxx.xxx", "user", "pword"); > if (!$dbcnx) { > echo( "Unable to connect to the " . > "database server at this time.Try again later" ); > exit(); > } > > RESULTS in the error message Unable to connect to the database > server. > > When I do a netstat -a on the PC with MySQL I dont see any listening > ports, should there be. Well there should be. You can try telnet xxx.xxx.xxx.xxx 3306 If that fails then you most likely don't have mysql running on xxx.xxx.xxx.xxx -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Hearts will never be practical until they can be made unbreakable. -- The Wizard of Oz */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Remote Connection to Mysql
On Friday 22 March 2002 07:42, Marcus Rigby wrote: > Hi all, > I know there are plenty of remote connection posts herebut none have > helped me solve my problem. > > I have 2 win98 machines on a novell network, both have static IP > addresses, and both machines can ping each other. One machine is > running a webserver and the other the Mysql server, and I cannot get > scripts on the webserver to connect to MySql. > > Using : > $dbcnx = mysql_connect("xxx.xxx.xxx.xxx", "user", "pword"); > if (!$dbcnx) { > echo( "Unable to connect to the " . > "database server at this time.Try again later" ); > exit(); > } > > RESULTS in the error message Unable to connect to the database > server. > > When I do a netstat -a on the PC with MySQL I dont see any listening > ports, should there be. Well there should be. You can try telnet xxx.xxx.xxx.xxx 3306 If that fails then you most likely don't have mysql running on xxx.xxx.xxx.xxx -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Hearts will never be practical until they can be made unbreakable. -- The Wizard of Oz */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Remote Connection to Mysql
Hi all, I know there are plenty of remote connection posts herebut none have helped me solve my problem. I have 2 win98 machines on a novell network, both have static IP addresses, and both machines can ping each other. One machine is running a webserver and the other the Mysql server, and I cannot get scripts on the webserver to connect to MySql. Using : $dbcnx = mysql_connect("xxx.xxx.xxx.xxx", "user", "pword"); if (!$dbcnx) { echo( "Unable to connect to the " . "database server at this time.Try again later" ); exit(); } RESULTS in the error message Unable to connect to the database server. When I do a netstat -a on the PC with MySQL I dont see any listening ports, should there be. Is anybody able to shed some light on this for me??? Thanks Marcus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php