Bug #105840 IPv6 address wildcards not validating correctly
Submitted: 8 Dec 2021 16:15 Modified: 9 Dec 2021 6:06
Reporter: Tad DeVries Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.27 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[8 Dec 2021 16:15] Tad DeVries
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\tadd\AppData\Roaming\MySQL\Workbench\log\wb.log]

Workbench is not validating IPv6 addresses with single colons and wildcards.

db8:5700:f:1110:%     does not validate when I believe it should
db8:5700:f:1110::%    does validate but is not correct for the subnet definition I need to use. It implies zeros padding where I don't want it defined.

Mysql CLI client handles this formatting correctly so I can add users by CLI but that is not as convenient as using workbench. 

How to repeat:
Add a user workbench and type an IPv6 subnet into the host matching.
[9 Dec 2021 6:06] MySQL Verification Team
Hello Tad DeVries,

Thank you for the report and feedback.