We help IT Professionals succeed at work.

Mysql Vpn

Tony
Tony asked
on
Mysql VPN.
HI..how do I share or connect Mysql using a Internet private VPN?   NOTE: I ms access as a front end....also Work bench to manage
Comment
Watch Question

David FavorFractional CTO
Distinguished Expert 2019

Commented:
1) You'll only do this if you'd like to reduce your connection speed down to VPN speed, usually much slower than raw connection speed.

2) If you require max connection speed, you'll create a TLS cert to encrypt your data flow.

So anyone can see the data flow then, except seeing the data is useless, as it's encrypted.

3) For fastest speed, you'll run your site/app code on the same machine with your MariaDB/MySQL instance, so your data flow runs at RAM speed, rather than network speed.
Software & Systems Engineer
Distinguished Expert 2019
Commented:

You need to clear this a bit.

If you have VPN then your MySQL looks like another machine in your network..

For example if your IPs are in the range of 192.168.1.1-192.168.1.100 your mySQL would appear as 192.168.1.101 is just a matter of the VPN connection and your network configuration.

Other than that you can connect either using its IP or its Name e.g. TonysMySQL

Distinguished Expert 2019

Commented:
As others pointed out much more detail is needed

If you have ssh access to where mysql server is look at ssh tunneling

Author

Commented:
OK. I will Mr. John Tsioumpris solution and go back to you if this works.

Author

Commented:
thank you.
David FavorFractional CTO
Distinguished Expert 2019

Commented:
Best test your VPN speed, if speed is important.

MariaDB/MySQL already bake in native TLS support + TLS security is always stronger/faster than VPN security, because you can tune your ciphers.

With a VPN there is no tuning. Your speed is determined by the VPN IP you happen to connect through.