Bug #45486 some acl entries are ignored while they shouldn't be
Submitted: 14 Jun 2009 10:11 Modified: 15 Jul 2009 9:13
Reporter: Arkadiusz Miskiewicz (Basic Quality Contributor) Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:5.0.77 OS:Linux
Assigned to: CPU Architecture:Any

[14 Jun 2009 10:11] Arkadiusz Miskiewicz 
Description:
 'db' entry 'iflex2 amaxpl_ip@"%"' ignored in --skip-name-resolve mode.

But this access entry is perfectly valid for IP addresses, too. It shouldn't be ignored even if skip-name-resolve is used.

How to repeat:
Grant something@% ACL, enable skip-name-resolve and see logs.

Suggested fix:
Don't ignore such entries. Apply them to IP addresses, too.
[15 Jun 2009 9:13] Sveta Smirnova 
Thank you for the report.

But version 5.0.77 is a bit old. Additionally I can not repeat described behavior. Please try with current version 5.0.83 and if problem still exists provide GRANT statement you used and full error log file.
[15 Jul 2009 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".