we need remote connections from/to our mysql server for two reasons.
- testing/changes: we want to connect to a remote mysql server to manage databases with e.g. sqlYOG
- our production web server will be using a mysql server not running on the same IP, so we need to configure our application to use an external remote mysql server
I've read about using ssh tunnels and limiting user access to mysql based on IP. We have IP's that change around every 24 hours so that could be a bit of a party pooper.
We are looking for a safe, yet flexible way to set up remote connections to mysql. Any advice on this?