不能连接到mysql服务器127.0.0.1,MySQL主机':: 1'或'127.0.0.1'不允许连接到该MySQL服务器...

I have a strange issue on a web server (Windows Server 2012) with MySQL 5.7.16.

I can't connect anymore to mysql server, I don't know why.

If I type mysql -uroot -ppassword appear an error

ERROR 1130 : Host '::1' is not allowed to connect to this MySQL server or

ERROR 1130 : Host '127.0.0.1' is not allowed to connect to this MySQL server

I tried to use another user with all privileges and I've seen that in host there is only localhost (not 127.0.0.1 or ::1)

How can I login with root@localhost and not with root@127.0.0.1?

It's very frustrating...

Every account trying to use @127.0.0.1 or @::1 but there exist only localhost in host and I can't change it.

If I type mysql -uroot -ppassword I see

ERROR 1130 : Host '127.0.0.1' is not allowed to connect to this MySQL server

Same if I type mysql -uroot -ppassword -h localhost or anything else

解决方案

Ok i Fixed...

I've comment "skip_name_resolve" in my.ini and everything is back to work.. i really don't know why because this record was in my.ini also yesterday..last week.. last month..