Connect to remote MySQL database using SSH

[anda_skoa]

I dont know works it or not.

The first step of debugging a multi layered problem is to debug its single layers.

I need to create SSH connection to database. HOW TO DO THIS?

This is totally irrelevant until you have verified that the tunnel works.

Cheers,
_

[_Dron_]

Even if it works - how to put data from QtDatabase object into SSH tunnel? Then, how to extract data from SSH tunnel and put it into QtDatabase object and after that fetch an answer?

Have you ever written a SSH connection to remote db? If so, please show an example of your code.
Thanks.

[anda_skoa]

An SSH Tunnel is indistinguishable from the client and server perspective.

The client connects to its side of the tunnel like it would connect to the server,
The server gets connections from its side of the tunnel like it would from the clients.

And the tunnel doesn't care what it is transporting. It just accepts connections one one end, creates a connection on the other end and then passes data back and forth.

You can easily try this with a stand-alone SSH client that supports tunnels.

Cheers,
_