Linking MYSQL and Libre BASE with SSH
On a Ubuntu server (and for clients) I am using Libre BASE as the GUI and will have many clients using this GUI to link into a MYSQL database which will store the data, forms, reports, etc. Clients are using Ubuntu and MYSQL server is hosted on Ubuntu server.
I want to use a SSH tunnel to link the Libre BASE program client to the MYSQL server, over the internet eventually but at first I will use localhost to get to it working to prove its viable.
Does anyone know of someone who has done this linkage using SSH?
The ‘built in’ linkage choices, which originate from Libre BASE, are ODBC and JDBC, but we’d prefer SSH for its more robust and ‘generic’ security.