PHP/MySQL Connection Problem

[cmhunt]

Hi

I am running PHP on one machine and want to query a MySQL database on another machine at another site using mysql_connect(). Without our firewall on, the PHP runs fine but with the firewall on, I get a "Can't connect..." error.

The problem is that I need to know which specific port this is using as we can't afford to leave the firewall off.

Thanks in advance for any help.

Chris

 

[sleipnir214]

The default MySQL port is 3306

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[cmhunt]

Sorry, I should have mentioned that we have tried that. Not really knowing too much about this sort of thing, isn't that the port that I am connecting to on the machine that's running MySQL? Is that the same one that would be used on the machine running the PHP??

Chris

 

[dkdude]

Yes, same port number. Mine is 3306 too. Have a look in my.ini located in the windows folder (on MS systems only, of course).

Good Luck §;O)


Jakob

 

[butkus]

The firewall would need to allow 3306 port traffic.

 

[sleipnir214]

cmhunt:

I'm not sure what you mean by "[/i]Is that the same one that would be used on the machine running the PHP[/i]".


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lupin3]

try this to connect:

$username="username";
$password="password";
$database="your_database";

mysql_connect("localhost","username","password"
@mysql_select_db("database&quot or die( "Unable to select database"

 

[cmhunt]

Thanks to everyone for their help. Not sure why but the first time we tried to unblock that port, it still didn't work. During further testing it seemed to work fine - strange!! While I'm here, I should also point out to anyone else who follows this problem with an "Access Denied" error as I was after adding a new user, that they should flush privileges in MySQL. All worked fine then!!

Thanks

Chris