Just wondering about best security practices for remote admin of a MySQL db in a production, internet connected server?
Specifically if the website is on the same server then it makes sense to bind the server to 127.0.0.1, but then this would only allow remote admin from the remote server (not really remote), and thus in my case ssh, where i much prefer the GUI that mysql comes with.
What is the best way to use the GUI on a remote server. VPN? ssh tunnel? ssl? is there even a need to in peoples minds? because most of the setup should be done in dev and then cloned over by scripts etc?