Bug #37890 netmask feature in GRANT should not be limited to only 8,16,24,32 bits
Submitted: 4 Jul 2008 21:37 Modified: 31 Jul 2009 16:41
Reporter: Jonathan Buhacoff Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S5 (Performance)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: grant, netmask

[4 Jul 2008 21:37] Jonathan Buhacoff
Description:
Why bother implementing the netmask feature if you only allow 8, 16, 24, or 32 bits?   Those specific values correspond exactly to using the % wildcard  like 1.%,  1.2.%,  1.2.3.%, and 1.2.3.4 ...   It's such a waste!  Let me specify my 255.255.255.224 netmask so I can allow connections only from my small subnet instead of having to list them individually!

How to repeat:
See online reference documentation.
[19 Jul 2008 14:14] Valeriy Kravchuk
Thank you for a reasonable feature request.
[31 Jul 2009 13:01] Valeriy Kravchuk
We have a patch for this contributed in bug #46492, so let's call this a duplicate.
[31 Jul 2009 16:41] Jonathan Buhacoff
Thank you!