How to access a database via IP
My Qt5.5 app is simple, just a QMainWindow with a TableView that I query a database (MySql) in our server, and it works well. The problem is when I'm out of here, far from my Server. How can I comunicate with my database in my server via IP. I'm looking for a exemple, a material to read, or a description.
Thanks for your support.
You have to use the "port forwarding" feature of your router. MySQL usually uses port 3306. So tell your router to forward port 3306 from the Internet to your Mysql server (example 192.168.1.200:3306).
But first consult a security expert since "Port Forwarding" means you're opening a door on your firewall. And 3306 is standard port so it will be hit by port scanners.
we use VPN for this.