About MySQL(SSH tunnel) login

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.

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?

but i cannot login. I used the same username and password on workbench and heidisql.

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.

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.

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.

OK, I'll try that, thanks again.

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)