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 firstname.lastname@example.org (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.