I have a Linux-based web server running with the LAMP package. For security reasons, the sever only allows logins via SSH and denies regular password login attempts. I want to use the MySQL ODBC driver within Microsoft Access 2016 to connect to this server for data analysis purposes, but I do not see an option in the ODBC Data Source configuration to add a source that works with SSH.
My question is, is there a way to configure the ODBC tool to work with SSH, or is there a tool that can bridge the gap? Thanks.
From now on, anything sent to localhost:3306 on your local computer will be forwarded to your MySQL server, it looks as if the MySQL server is installed on your local computer, happily coding!