RE: [PHP-DB] Remote Connection to Mysql

2002-03-23 Thread Boaz Yahav

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

2002-03-23 Thread Jason Wong

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

2002-03-22 Thread Marcus Rigby

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