MySQL 5.7.16 lost root privileges

[Marco Bonciolini]

i have a strange issue on a web server (Windows Server 2012) with MySQL 5.7.16. Root lost privileges, i don't know why.

If i type mysql -uroot -ppassword appear an error (root@127.0.01) Access Denied using password YES

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)


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.


So i don't know how to fix it.