What ports should I be opening thru my firewall to access MySQL behind it

Question

I currently have a web server in front of a firewall and my MySQL DB behind the firewall.

I have already opened port 3306 for tcp, but still cannot connect thru the firewall.

Any ideas?

Thanking all in advance :)

Answer 1

Are the web server (presumably Apache?) and the database on different machines? Databases are usually only configured for local access.

Answer 2

There is not only the firewall that has to be configured, but MySQL itself, too.

For instance, take a look at this article : How Do I Enable Remote Access To MySQL Database Server?

Answer 3

Issue was not with MySQL. MySQL was setup correectly, my firewall had gone south. Got a new firewall adn worked fine.