Firewall rule MySQL to Windows 2008

Mar 18 at 7:29am - admin

Note: If you plan to enable network access to your database server, then you must open a TCP port in Windows Firewall before running the configuration wizard.

By default MySQL uses TCP port 3306, but it can be changed via Configuration Wizard or manually in my.ini file. To create a Firewall rule for the default MySQL TCP port, run this command from Windows command line prompt.
 
C:\>netsh advfirewall firewall add rule name="MySQL Server" action=allow protocol=TCP dir=in localport=3306
 
This command can be modified for any port or rule name as well.
  
If you are looking for a good step by step approach to installing MySQL then go here.