Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 04-18-2005, 04: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
Old 04-18-2005, 07:37 PM   #2 (permalink)
sde
Moderator
 
sde's Avatar
 
Join Date: May 2002
Location: us.ca
Posts: 4,470
sde is on a distinguished road
no need to cross post.
__________________
Mike
sde is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with outside connection to mysql using a php page ericanca PHP 11 07-19-2005 10:33 AM
DAO wrapper class for Connection Pooling using JNDI Mazzman Java 4 03-29-2005 07:54 AM
WML PHP and MySQL rmill9681 PHP 10 11-20-2004 12:59 PM
cant connect to mysql databases using php eran PHP 11 08-07-2004 08:02 AM
Help with setting up mySQL and PHP Ilya020 PHP 11 03-19-2003 05:10 AM


All times are GMT -8. The time now is 07:36 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting