VPN with dedicated IP to connect AWS RDS

tanky's profile image tanky posted 2 years ago in General Permalink

Hi all, I am new here, hope I do not violate any rules in the forum.

My problem is I can successfully connected the Database with MySQL Workbench (over SSH mode), but when I switch to HeidiSQL, I cannot connect to server.

plink.exe unable to use key file "xxxxx.key" (OpenSSH SSH-2 private key (old PEM format)) Using username "xxxx"

Is there any setting I got it wrong. Thanks

3 attachment(s):
  • heidisql1
  • heidisql2
  • heidisql3
ansgar's profile image ansgar posted 2 years ago Permalink
  • On the "settings" tab, use "127.0.0.1" as IP/Host. The server's host IP should only be entered in the "SSH tunnel" tab.
  • On the "SSH tunnel" tab, use a different local port, such as 3307. Otherwise you may get two conflicting ports.
tanky's profile image tanky posted 2 years ago Permalink

Hi ansgar,

Thanks for your reply. But I tried your suggestion and not success.

should i use plink or ssh to connect?

1 attachment(s):
  • mysql
tanky's profile image tanky posted 2 years ago Permalink

Hi ansgar,

I can connected with 3307 changes, and keep the DB host to remote address

And I can connect now!

Many thanks for your reply.

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