I have been developing a MySQL database backup and restore appliation in windows forms. This application crates a dump of a mysql database at remote location and imports everything from the dump file back into local mysql database.
MySQL database is located at the server which hosts my php website. So it is obvious that if i want to access that mysql server from my local network, i have to allow mysqlserver at remote location to allow me to connect from my company's local network, by adding the public ip of my network in the lists of ip that remote mysqlserver can allow connections from. I set this thing in CPanel.
It's working fine.
But my question is that, i have anathor software called let's say mysqlyog, that can connect to remote mysqlserver without allowing my local networks ip in the cpanel of remote server.
So i mean to say that if mysqlyog can do that, why my application can't do that the same way msqlyog does.
What kind of mechanism do they apply?
i just don't know how to do this in windows forms and C#.
how do they bypass the firewalls and or just connect to remote mysqlserver.
What is the trick?