Can't connect Visual Studio/VB Win-desktop App to MySQL on Debian 8 OPi

geneous42

I have just run into a roadblock, namely connecting a Visual Studio/VB 2015 desktop (Win 7) App to MySQL out on my LAN.. I have most of the MySQL Utilities installed (see attached photo). "MySQL Data Provider" does show when I try to Add a Connection, but the "Test Connection" fails. So does MySQL Workbench and MySQL Utilities: Shell, mysqlsh & utility console. The last three give a clue to the connection problem, namely that "the target machine actively refused it." I know other connections work: phpMyAdmin on at least two browsers, several of my own html and php web pages, Putty (terminal emulator) and PuttyFTP clients all work. A montage of screen captures showing all the evidence is attached.

I suspect the Debian 8 based server needs to grant some sort of permission, but I don't have the experience to tell. Appreciations in advance for any help.

Gene

geneous42

Found the problem!   By default, MySQL only listens for connections from the local host where is where phpMyAdmin, for example, runs (even though its display is on my WinDeskTop browser).  So, the bind-address configuration parameter must be changed to allow remote clients access, such as Visual Basic & MySQLworkbench since they are "remote" to the MySQL platform.  See http://do.co/2rraNqh  Actually located /etc/mysql/my.cnf

admin

geneous42 replied at 2017-6-2 12:51
Found the problem!   By default, MySQL only listens for connections from the local host where is whe ...

Good to hear that! And also thanks for your illustration at your experience.