Re: MySQL 5.7 + Windows 10 remote access
To test basic connectivity, take WorkBench and its complexities out of the loop. Open a "DOS" command window. Make sure the MySQL installation bin folder is in the system path, or navigate to that folder, and execute ...
mysql -uroot
The installer may have set up the root user on localhost only, with no password. If a password has been set, add -p to that command and supply the password. When connected, run ...
select user, host, authentication_string from mysql.user;
If host is 'localhost', that's why mysql responds only to that. It's not very secure to make root access available from everywhere, but for testing purposes, run this ..
update mysql.user set host='%' where user='root';
flush privileges;
and make a note to change it back when you later define network users. Log out and log back in again with ...
mysql -hVSRVFORIX -uroot
Do likewise with 192.168.67.15.
If this doesn't address the problem, post here the result of the above Select statement.
Edited 1 time(s). Last edit at 05/07/2016 11:04AM by Peter Brawley.