Flyway Over SSH tunnel

0
votes

I'm trying to connect Flyway to an AWS EC2 MySQL instance using TCP over SSH.

Can anyone help with this JDBC URL:

flyway.url=jdbc:mysql:/0.0.0.00:3306/database

The connection error is;

Could not connect to address=(host=0.0.0.0)(port=3306)(type=master) : Connection timed out: connect

1
mysqlamazon-web-servicesflyway
If using a local tunnel to remote host, your connection string might need the local loopback address 127.0.0.1 – Edward Comeau

1 Answers

1
votes

You should try to use the local loopback IP address which is now the virtual location of your database because of the SSH tunnel you're using.

Your connection string would be;

flyway.url=jdbc:mysql:/127.0.0.1:3306/database