Bug #78166 Cannot connect using full IP and same IP with wildcard in the end.
Submitted: 21 Aug 2015 12:39 Modified: 2 Oct 2015 17:25
Reporter: Joey Aldrin Cruz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S2 (Serious)
Version:5.5.41-log OS:Linux
Assigned to: CPU Architecture:Any
Tags: Connection

[21 Aug 2015 12:39] Joey Aldrin Cruz
Description:
I'm not sure if this is a bug, but is it a problem when you grant a user in a server IP and in the same IP with just wild card in the end? I just encountered that today and it's really weird that the user cannot connect but when we removed the IP (w/out wild card it works).

 GRANT USAGE ON *.* TO 'user'@'192.168.3.%' IDENTIFIED BY PASSWORD 'XXXXXXXXXXX |
| GRANT SELECT, INSERT, UPDATE ON `db`.* TO 'user'@'192.168.3.%'

AND

GRANT USAGE ON *.* TO 'user'@'192.168.3.10' IDENTIFIED BY PASSWORD 'XXXXXXXXXXX |
| GRANT SELECT, INSERT, UPDATE ON `db`.* TO 'user'@'192.168.3.10'

How to repeat:
Create the same user name with a grant on IP only and the same IP with wild card in the end.

Suggested fix:
Deleted the user that is granted on the IP without wild card and it works.
[2 Sep 2015 17:25] MySQL Verification Team
Hi,

So far, I am not able to repeat the behavior, so I have two questions:

* Is '192.168.3.10' the real address of the host. This looks like a dynamic IP, so, please, can you re-check whether the address is exactly like the one for which privileges are granted

* Check with latest, or near-latest version of 5.6
[3 Oct 2015 1: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".