distal-attribute
distal-attribute
distal-attribute
distal-attribute

About MySQL(SSH tunnel) login

User, date Message
Written by sky.tian
4 months ago
Category: General
7 posts since Thu, 08 May 14
When I want to login using MySQL(SSH tunnel), I have to use plink.exe and provide ppk file. But my company's MySQL server doesn't use public/private key mechanism, it uses password to log in.
I soon find that workbench has the function that allows us to login by TCP/IP over SSH, and it does not need plink and ppk file, it need a SSH password, and I successfully logged in.
I hope HeidiSQL can provide such function: to log in by(SSH tunnel) with a password, like wordbench.
Written by ansgar
4 months ago
5009 posts since Fri, 07 Apr 06
Private key file is not a mandatory field in HeidiSQL, is it? Just do not put any file here and try user/password.

But using plink.exe is mandatory, as HeidiSQL does not own some internal SSH library. Plink is wonderful for free software, isn't it?
Written by sky.tian
4 months ago
7 posts since Thu, 08 May 14
but i cannot login. I used the same username and password on workbench and heidisql.

Written by justpusherMoney, Euro
4 months ago
28 posts since Wed, 31 Mar 10
sky.tian, I think you should first try running plink.exe without HeidiSQL and test if you can connect to the server using it.
Run it from commandline: plink.exe username@server
and when prompted, enter your SSH password.

Written by sky.tian
4 months ago
7 posts since Thu, 08 May 14

justpusher wrote: sky.tian, I think you should first try running plink.exe without HeidiSQL and test if you can connect to the server using it.
Run it from commandline: plink.exe username@server
and when prompted, enter your SSH password.


Thank you justpusher.
When I tried to connect to the server by commandline, I successfully logged in, and the server prompted that some key to be added or downloaded? I chose 'yes'.
Now I can log in from HeidiSQL.
smile
Written by justpusherMoney, Euro
4 months ago
28 posts since Wed, 31 Mar 10
When you connect to the server first time, plink asks you confirmation that you trust the server. This could be reason why HeidiSQL could not connect to the server. Download the newest nighty build of HeidiSQL, there is better integration with plink.
Written by sky.tian
4 months ago
7 posts since Thu, 08 May 14
OK, I'll try that, thanks again.
Written by vitonaxi
2 months ago
1 posts since Wed, 09 Jul 14
If you want to connect to server from "outside", not from Plone, you have to build SSH tunnel to connect.

Build SSH tunnel by running the follow command in the terminal window:
ssh login@server -L 3306:127.0.0.1:3306 -N
where login and server (something like login.quintagroup.com) are your SSH connection details that can be found at your quintagroup account (https://my.quintagroup.com/username)
 

Please login to leave a reply, or register at first.