Search code examples
sshforgeheidisql

Unable to ssh into database with heidisql

Configuration I am using:

Network type : SSH Tunnel
Hostname : 127.0.0.1
User : *Database Username*
Password : *Database Password*

SSH Host : Server IP
Port : 22
Username : *Username*
Private key file : .ssh/id_rsa

Error I am getting:

PLink exited unexpected. Command line was: pling.exe -ssh [email protected] -P 22 -i "C:\Users\Ruben\.ssh\id_rsa" -N -L 3307:127.0.0.1:3306

Can ssh with no problem on my console. So the ssh key is properly set up. What am I missing here?

edit: exact same configuration works find in MySQL Workbench

Solution

  • Problem comes from the fact that HeidiSQL only supports putty for ssh tunnels and Putty doesn't support OpenSSH.

    So, you have to download puttygen.exe. Run it. Go to conversion and save as private key. You can then use that private key to connect on HeidiSQL.

    You can find some more information here