Connect to DB installed into dedicated VPS (private networking)
Hi, what is the best and secure way to connect to MySQL DB via Sequel PRO or MySQL Workbench, hosted into a dedicate VPS that is connected to app servers via private networking?
If MySQL daemon is listening to private IP, it will not be available from public IP (obviously, I’m scared about exposing my DB droplet to public internet).
I’m using the 2nd server configuration illustrated in this guide (https://www.digitalocean.com/community/tutorials/5-common-server-setups-for-your-web-application), called “Separate Database Server”.
Thanks a lot
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.