MySQL Bugs: #62714: skip-name-resolve means can't login from localhost

Bug #62714	skip-name-resolve means can't login from localhost
Submitted:	13 Oct 2011 4:21	Modified:	19 Dec 2012 18:15
Reporter:	Paul H	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S2 (Serious)
Version:	5.5.11	OS:	Windows (Server 2008 standard)
Assigned to:		CPU Architecture:	Any

Description:
When a user attempted to log into the mysql server via VPN, it reported back
"Can't get hostname for your address"

I added skip-name-resolve to my.ini and restarted the mysql server,
and now it can't log onto the server from the localhost.
ERROR 1130 (HY000): Host '::1' is not allowed to connect to this MySQL server

It does not help if I change the host in the 'user' permissions table to 127.0.0.1, but it does work if the host is changed to '::1'.

How to repeat:
See description for info.

Thank you for the report.

This looks very much like bug #22118. Please check if this is same as your case and if any of workarounds there is working for you.

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".

Re-opening bug,
as the workarounds specified in bug 22118 do not solve the problem.

Their workarounds involve using 127.0.0.1, however I already stated that does not work.

I must instead use ::1 instead of 127.0.0.1 in the user table.

Thank you for the feedback.

After more thinking I still think this is same issue as bug #22118 (skip-name-resolve does not allow to connect from localhost) even having you should use ::1 instead of 127.0.0.1

So I am closing this report as duplicate.

Please subscribe to bug #22118 and test fix when it is available.