Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 machines, one is used as to host application ( Application Server), another is used to host database ( database server). Both are windows XP.

Now as the App Server needs to access the database server, I need to set the firewall to allow for app server db access the database (mysql), how to configure this?

share|improve this question
up vote 2 down vote accepted

If the only access the application server needs to the database server is MySQL, then you just need to add a port exception to the Windows Firewall on the database server for the application server.

  • In the Windows Firewall control panel applet, on the "Exceptions" tab, click "Add Port".

  • Enter "MySQL" (or anything you want... "Bob", "Ice Cream", etc) as the "Name", and "3306" as the "Port Number".

  • Click the "Change Scope..." button.

  • In the "Change Scope" dialog, click the "Custom" radio button. Enter the IP address of the database server.

  • "OK" your way back out.

  • From the application server computer, test connectivity to the database.

share|improve this answer

Mysql defaults to listen on port 3306. So you would need to allow your app server access to port 3306 on your database server.

Check out here for more documentation.


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.