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.
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.