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

Question

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 <HY000>: Host '::1' is not allowed to connect to this MySQL server or
ERROR 1130 <HY000>: 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 [email protected]? 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 <HY000>: 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

Answer 1

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

Answer 2

I had the same message after a fresh installation with the no-install zip and solved it as follows. Perhaps this could have been a solution for your problem too:

1. Stop the MySQL server or service.
2. Open a Command Prompt window with administrative rights and go to the bin folder in the MySQL install directory.
3. Start MySQL with skip-grants-table and don't forget your config file:

mysqld --defaults-file=[filename] --skip-grant-tables

4. Open another Command Prompt window and go to the bin folder again.
5. Now you can login:

mysql -u root -p

6. Show the users with:

SELECT user, host FROM mysql.user;

7. Verify there is one 'root' with host 'localhost'.
8. Change the host:

UPDATE mysql.user SET host='%' WHERE user='root';

9. Exit the mysql program and close the Command Prompt window.
10. Type Ctrl-C in the other Command Prompt window to stop the server, then close the Command Prompt Window.
11. Start MySQL as you normally would and verify that you can login.