Bug #46492 Patch: CIDR NETMASK in host
Submitted: 31 Jul 2009 12:49
Reporter: Lenz Grimmer Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: CIDR, Contribution

[31 Jul 2009 12:49] Lenz Grimmer 
Description:
This bugreport is supposed to keep track of a patch contribution by David Dufresne for WL#2686:

"Currently you can specify a NETMASK in the host portion of the connection info but it only dictates which class of the address to apply (8,16,24,32 bits).  You 
cannot apply 28 bits of the address so this does not work as normally expected:
192.168.1.96/255.255.255.240"

The patch is here: http://lists.mysql.com/internals/35903

David signed the SCA on 2009-04-14

How to repeat:
Apply the patch, observe that it implements WL#2686
[31 Jul 2009 13:02] Valeriy Kravchuk 
Bug #37890 was marked as a duplicate of this one.
[11 May 2015 20:40] Simon Mudd 
I guess it would be nice to have this patch or something similar incorporated.

A recent request for access to one of my systems required access from a.b.c.d/20 and so the typical user@'a.b.c.%' did not really work. Thus a more formal definition of a MySQL user such as 'user'@'a.b.c.d/x' would be quite handy. A CIDR type notation is probably cleaner.

As there is a patch then understanding why it's not been used would be helpful.