0
I got a Windows PC with MySQL installed and I'll need to access it remotely via ODBC from another machine on a different network. Is it possible and how can I do that?
I've Googled and found a lot of scattered information that confused me even more. I guess on the Windows PC, I'll need to install MySQL Connection ODBC Driver and create an ODBC System DSN. It works locally. But how can it allow remote access? On my remote machine, I plan to use PHP odbc_connect to connect to the Windows PC ODBC. Appreciate if anybody can provide the detail steps on how to configure it.
Kenaz Chan
Posted 2019-08-02T09:46:06.973
Reputation: 1
By your comment about allow remote access on the database I'd say your problem is not the ODBC configuration, but permission for the MySql user to login remotely. Can you login on the database from a remote computer using MySql Query Browser or another tool alike? If not, check this topic
– Ronaldo – 2019-08-02T14:20:04.813