PYTHON MYSQL SSH TUNNEL INSTALL

Now, if you want to check something or do something on the DB server. But, for security, the DB server is never exposed to the internet and is kept on the local network, which will be accessible via the SSH server, as the SSH server is on the same local network. On the SSH server, because we are running the Web server, port 80 would be open to all, because then only the website or the web application hosted on that server will be available to its users. Let's take another example If we are using AWS service and we have two servers one is a DB server and another is the SSH server on which the Web Server is running.

In such a scenario, we set up an SSH tunnel with the remote server, to securely connect to the local network of the remote server to access the 3306 port on the remote server. In this case, if you want to access the DB server from your local machine(connected to the internet), you won't be able to do it.

If we have a database server, let's say MySQL is running on a remote server with some IP address and for which the port number 3306 which is the default port for MySQL is only available on the local network of the remote server. Let's take a simple example to understand this. So let's get started!Īn SSH tunnel or SSH port forwarding is a mechanism to establish a secure connection between a client machine and a server. If you are a Windows user, I would recommend using the Mobaxterm application for doing this. You can easily setup SSH on Mac without doing any extra work.

PYTHON MYSQL SSH TUNNEL INSTALL

Yes, we do not have to install any other application to do so, as we do in Windows. If you want to set up an SSH tunnel with your remote server using your Macbook, you can easily do so using the default Terminal application available in the Mac OS.

Python mysql ssh tunnel