firewall an mysql

Question

firewall an mysql

Hi there,

I have a problem with the built in firewall: I set up a MacMini as a webserver using Leopard client and activated php and mysql. When I tried to connect from another Mac to the mysqld the connection timed out. As I don't want to leave this Mini visible in the Internet without firewall, I cannot switch the firewall off, so I added a rule to allow incoming connections for the mysqld.
Unfortunately the log-file still shows connection denied for mysqld... With other apps this works fine, so does anybody have an idea why not with mysql?

thanks and greetings
SK

MBP 2.16 GHz Core 2 Duo, Mac OS X (10.5.1)

Posted on Sep 7, 2008 10:31 AM

Reply

Answer 1

orangekay

Level 5

4,085 points

Sep 7, 2008 11:18 AM in response to Sven Koesling

Leopard's application firewall is ill-suited for this sort of thing, and it's not generally a very good idea to allow database connections from outside networks. What exactly are you trying to do?

Reply

Answer 2

Sep 7, 2008 1:17 PM in response to orangekay

well, actually I'm trying to set up a web app. My Database runs on my Mini-"Server" and I'm developing on my MBP. Thats why I want to be able to connect from my MBP to my Mini. They are on the same network.
And yes, from the outside there should be no way in (if I configured my router correctly 😉 ).

But how comes, that for some apps the firewall setting works, but not for mysql? Maybe because it's a binary, not a Mac App package?

Greetings
Sven

Reply

Answer 3

orangekay

Level 5

4,085 points

Sep 7, 2008 2:04 PM in response to Sven Koesling

If you're behind an NAT router then that's all the firewall you need. Turn Leopard's off.

Reply