Connecting to a MySQL db on a remote server

My DB is on one server, that is protected by SSH.
I need a connection string that will let me tunnel into the server, pass credentials, access MySQL & make a connection.

I need this string for a merge application. I can't seem to connect to any DB that is behind SSH.

Please advise the syntax for a connection string to work.

Thanks in advance.

1 answer

I had the same problem but I think I have a solution.
Firstly download mysql odbc driver then go to this help file and go to Using ODBC driver-> Connection Strings.
There you will find connection options and a sample of a connection string, you just need to insert a required parameter from a table.
Good luck!