Bug #88615 MySQL Installer running netsh firewall instead of netsh advfirewall firewall
Submitted: 23 Nov 2017 0:50 Modified: 10 Mar 2018 0:41
Reporter: Javier Treviño Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S3 (Non-critical)
Version:1.4.0 OS:Any
Assigned to: CPU Architecture:Any

[23 Nov 2017 0:50] Javier Treviño
Description:
The MySQL Installer for Windows currently issues a "netsh firewall" command to create a Windows Firewall exception to open a specific port for the MySQL Server.
According to the following Microsoft article, "netsh advfirewall firewall" should be used instead in more recent Windows versions:
https://support.microsoft.com/en-us/help/947709/how-to-use-the-netsh-advfirewall-firewall-...

Although there is no actual error, the recommendation must be followed.

How to repeat:
1. Install a MySQL Server
2. During its configuration, choose the option to open the Windows Firewall port
3. When executing the configuration look at the log and notice "netsh firewall" is used.

Suggested fix:
"netsh advfirewall firewall" must be used for Windows versions of Vista and higher or Server 2008 and higher.
"netsh firewall" must be used for Windows XP or Server 2003.
[12 Feb 2018 22:39] Javier Treviño
Posted by developer:
 
The configuration step that updates the Windows firewall runs "netsh firewall" or "netsh advfirewall" depending on the Windows version, where the latter is supported it is run instead of the former.
[9 Mar 2018 20:54] Ruben Dario Morquecho Valdez
Posted by developer:
 
win8, win10
-------------
now its used advfirewall for newer windows versions

"Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok."
bug fixed
[10 Mar 2018 0:41] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Installer 1.4.24 release, and here's the changelog entry:

The correct netsh command is used to control Microsoft Windows Firewall
behavior and it may differ depending on the version of the operating
system.

Thank you for the bug report.