I'm working on some software that has a local database, but also needs access to a database on AWS.
The database is behind a web server, so the way that I need to connect is to create an SSH tunnel to the web server, which will allow me to access the database.
I'm able to make that connection with:
plink.exe webserverdomain.com -P 22 -l username -i C:\path to file\private.ppk
I need help modifying this to allow me to then use the database connection string in my software to make the connection. I know some port mapping needs to be done, but I can't figure it out.
The local and remote database are both using port 3306, so I'm trying to use 3307 for the remote. I'm basically trying to replicate how heidi sql does this. Any suggestions?