MySQL can't connect using private IP address I have a fresh install of MySQL 5.7 on my Windows machine. When I make a connection using root@localhost, I am able to connect, but when i try to make a connection root@192.168.1.10 (the private IP address of my server) I  get the following error:

mysql 5.7 access denied for user 'root'@'192.168.1.10'.

I opened my my.ini file and added the line bind-address=0.0.0.0. I saved the file and restart my MySQL instance, but still not luck the same error appears.

I then tried:

**GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;**


This did not work either. I then tried to change the password for root to make sure I was using the correct password:

UPDATE mysql.user SET authentication_string=PASSWORD('password')  WHERE  User='root';


But no luck.
I have reinstalled MySQL and now everything works.