Then provide the user and password for the postgres database user you want to connect with. Now you just need to change the config for HeidiSQL to connect to ‘localhost’, port 5432. What this does it route all requests from localhost port 5432 to the connection it created through PUTTY and forwards them to the same port (hence the second 5432) Where “my local ssh profile” is the name of the session config you have saved in PUTTY. Open up a windows command prompt and navigate to the folder you have the Putty executables: cd "C:\Program Files (x86)\PuTTY"įrom there, run the following: plink -L 5432:localhost:5432 "my local ssh profile" Make sure you have Putty installed (which included plink.exe). Click Test Connection to ensure everything is working and then Save to start. For using a tunnel to a PostgreSQL server, you will need to start a plink.exe command line seperately, and then let HeidiSQL connect to 127.0.0.1 on the port you specified in the command line.ĭid some research, and here’s what I ended up running that worked for me: Successfully connect via SSH tunnel to a Google Cloud SQL instance in Arctype. Test autossh access from Postgres to Mysql. Run command on Postgres server: autossh -L 127.0.0.1:3306:mysqlip:3306 rootmysqlip -N -i. With autossh, you can keep connection up all time. SSH tunnel is built into HeidiSQL for MySQL only. I solved it for mysqlfdw like that I use autossh for port forwarding.
I found the following article here that says:
In order to do that, I have to connect through an SSH tunnel. Was trying to connect to a PostgreSQL database running through VirtualBox locally, but is only exposed though SSH.
0 kommentar(er)
