View Single Post
Old 04-18-2005, 05:16 PM   #1 (permalink)
ericanca
Registered User
 
Join Date: Apr 2005
Posts: 6
ericanca is on a distinguished road
Unhappy 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
ericanca is offline   Reply With Quote