Thursday, February 21, 2013

How to set firewall rule in Window 2008 to allow remote server to connect to MySQL on port 3306?

I have 2 servers, 1 application server and the other 1 is database server. My database server is using MySql which is listening on port 3306. To enable my application server to connect to database server to port 3306, I have tried many effort in setting the Inbound rules and Outbound rules on Window 2008 firewall which I described in my previous post. Anyway, no luck in following the network engineer advice and now is my doubt on his ability...

1 magic tips which I search through the internet and it is great and it just works perfectly
netsh advfirewall firewall add rule name="MySQL Server" action=allow protocol=TCP dir=in localport=3306

No comments: