Bug #100918 Not able to start MySQL service when multiple IP addresses in bind-address

• Submitted: 22 Sep 2020 17:02
• Modified: 22 Sep 2020 20:11
• Reporter: Michael DaPrato
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: MySQL 8.0.21-commercial
• OS: Windows (Windows 10)
• CPU Architecture: Any
• Tags: bind-address

[22 Sep 2020 17:02] Michael DaPrato

Description:
what you did: 
Wanted to limit access to 2 machines, the server and another.  
Found this article: https://mysqlserverteam.com/the-bind-address-option-now-supports-multiple-addresses/
Added this line to my.ini with the IP address to the server and another machine on the network:
bind-address=127.0.0.1,192.168.1.82

what you expected to happen:
I expected the service to start, and users would only be able to connect from those 2 machines.

what happened:
The MySQL service would not start. This was in the err file:
2020-09-22T16:48:47.819546Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: The requested address is not valid in its context.

bind-address=127.0.0.1 works fine, and only connections on the server work, as expected.

How to repeat:
Add 2 IP addresses to the my.ini file -separated by a comma and try to start the service.

[22 Sep 2020 20:09] MySQL Verification Team

service was started successfully

Attachment: 100918.png (image/png, text), 35.63 KiB.

[22 Sep 2020 20:11] MySQL Verification Team

Thank you for the bug report. I couldn't repeat, please see prior attached screenshot. Thanks.