SSH key passwordless

[expired user #8535]'s profile image [expired user #8535] posted 9 years ago in Feature discussion Permalink
I'm running passwordless SSH connections to various DigitalOcean boxes I own and was wondering how to connect up HeidiSQL.

As it stands the SSH tunnel (with everything else set the way I talk to my servers) keeps on asking for a password. Is there any chance of a patch or upgrade so SSH tunnelling can be done passwordless?
ansgar's profile image ansgar posted 9 years ago Permalink
What exactly asks for a password? Is it a Windows dialog from HeidiSQL? In that case you may have activated "Prompt for password on demand". If it's the plink.exe command I can indeed fix that to leave away the password parameter.
[expired user #8358]'s profile image [expired user #8358] posted 9 years ago Permalink
I connect to various databases (MariaDB, Postgres) through an SSH tunnel, and don't get any password prompts as long as my SSH key is loaded into pageant or something similar. (It helps to specify the Putty private key file in the SSH tunnel connection tab, too.)

This way, whether your SSH keys have passwords or not, you never have to trust them to any program other than your key agent.
[expired user #8535]'s profile image [expired user #8535] posted 9 years ago Permalink
It's a Windows dialog. As HeidiSQL expects Plink I don't think I can route & use Pageeant instead.

Already have my PPK file working fine as I'm remoting with mRemoteNG. It's just in the SSH tunnel sequence its still asking for a password instead of relying on the SSH key.
jfalch's profile image jfalch posted 9 years ago Permalink
"I don't think I can route & use Pageeant instead" you dont use pageant instead of plink, but in addition to it. when pageant starts it loads the .ppk key(s); any time plink starts it looks if pageant is running - if so, it first tries the keys tat pageant has before trying to ask you. mRemoteNG seems to do the same.

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