Connecting to mySQL DB over SSh

[gsbeaton]

Hi folks,

has anyone tried connecting to a mySQL db over SSH?  I haven't found a connector that can do that easily.  I can create a tunnel using Putty, but ideally, I'd like to find a connector that does the whole thing in one go.

Any ideas?

many thanks

George

[CamilleA]

Hi,

I know this post is long time ago but did you find a solution for the problem?

Thank you !

[George_FTI]

Hi Camille,

Wow, yes that was a long time ago - almost 10 years!

I haven't had to do this for a while, but my vague memory was that rather than rely on an SSH connection sitting between QlikView and the mySQL server, I installed a certificate directly into mySQL and connected directly this way. This method is just as secure and means you don't need to worry about the extra layer of starting Putty every time you want to load new data.

I hope that helps.

George

[CamilleA]

Hi George,

Thank you very much, I will suggest this option to the dev team !

I hope it will suit them.

Camille

[timotheechalamet]

es ist so ein erstaunlicher und informativer Beitrag und bietet eine Menge Informationen, aber für die aktuellen Elektronikschrottpreise können Sie auch dies heraus überprüfen Mehr lesen