Re: 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 here....but 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( "<P>Unable to connect to the " . > "database server at this time.Try again later</P>" ); > 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 */