There are two major options for securely exposing access to your MySQL database over an unsecured network: an SSL connection or an SSH tunnel. The CData MySQL Driver provides a secure, live data connection to MySQL data from popular BI & Analytics, data warehousing, and application development tools, supporting both SSL connections and SSH tunneling. In this article, we explore how to use the CData MySQL Driver with SSH tunneling, which is often easier to build and more secure than SSL due to the driver’s built-in support for tunneling.
In addition to supporting encryption through SSH security protocols, which provide a strong record against attacks, MySQL can be configured to only accept traffic from ‘localhost,’ blocking all connections except for the configured tunnel.
An SSH