Help with outside connection to mysql using a php page Hi all,
I am having a problem connecting to my "mySQL" server from a computer outside my network.
I have port forwarding setup to goto the right machine on port 3306
firewall allows port 3306 also gave firewall rights to mysqld-nt.exe.
I am running mysql on win 2003 server IIS and PHP
versions.... 4.0.22 mysql 4.3.10 PHP
I put in an IP addy instaed of localhost in the conf.inc.php file as database hostname.... here is the code in that file...
<?
$dbh=mysql_connect ("24.21.XX.XXX:3306", "user", "pass") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("bytecon_baby");
?>
is this the right connection string? do I need to use a ODBC connection string? (ODbc is setup on the server for that database)
I am stummped.... do i need to give certain users authority to the database directory or the executable? I have given auth. to the internet guest account on these also.
Help please.
Eric |