Prev: Graphics questions
Next: Mathematica help (plotting solutions of transendental
From: dartar on 30 May 2010 06:46
The only instructions provided as part of the Mathematica
documentation to explain how to securely connect to a MySQL database
hosted remotely via SSL are a long list of (platform-specific) tweaks:

http://reference.wolfram.com/mathematica/DatabaseLink/tutorial/SecureSocketLayer.html

Is there no simple way to connect to a database via SSH using JLink as
with any other modern MySQL client?

Dario

From: David Reiss on 30 May 2010 23:45
The trick here is to set up an ssh tunneling process to the server
where mySQL is running.

Let's say that the IP address of the remote mySQL machine is
196.168.1.1 Then in a terminal sessoin you log into the remote server
using

ssh username(a)192.168.1.1 -L 3000:localhost:3306

Leave this terminal session open and then your mysql requests will be
passed to the 192.168.1.1 locatoin to its port 3306 (which is the port
that mySQL uses for requests). Of course the remote mySQL will need
to be set up to accept such requests.

Make sure to close the terminal session when you are done, since if
you try then to connect to a mySQL on your local machne it will try
instead to send the requests to the remot machine.

--David


On May 30, 6:46 am, dartar <dario.tarabore...(a)gmail.com> wrote:
> The only instructions provided as part of the Mathematica
> documentation to explain how to securely connect to a MySQL database
> hosted remotely via SSL are a long list of (platform-specific) tweaks:
>
> http://reference.wolfram.com/mathematica/DatabaseLink/tutorial/Secure...
>
> Is there no simple way to connect to a database via SSH using JLink as
> with any other modern MySQL client?
>
> Dario


From: David Reiss on 30 May 2010 23:46
A P.S. to my previous post. When port forwarding if you were
previously connecting to the database through localhost you will now
connect to it through localhost:3000.

--David

On May 30, 6:46 am, dartar <dario.tarabore...(a)gmail.com> wrote:
> The only instructions provided as part of the Mathematica
> documentation to explain how to securely connect to a MySQL database
> hosted remotely via SSL are a long list of (platform-specific) tweaks:
>
> http://reference.wolfram.com/mathematica/DatabaseLink/tutorial/Secure...
>
> Is there no simple way to connect to a database via SSH using JLink as
> with any other modern MySQL client?
>
> Dario


 | 
Pages: 1
Prev: Graphics questions
Next: Mathematica help (plotting solutions of transendental