Knime MySQL/JDBC Connector with AWS EC2 instance

[Shai]

I wish to use the knime DB Connector or MySQL Connector.
My database is on an EC2 Instance
I have a public DNS

ec2-3-NN-NNN-NNN.ap-southeast-2-compute.amazonaws.com
I have an elastic IP address which is a string of numbers
I believe that is what it is called
I am using port 3306
There is my root username and password
So I have the hostname, dbname, port, userid, password.

I keep getting a message
“The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.”

I need help to get this to work.

Is there anything I need to install on my computer to make this work?
Or is there some setting on my AWS EC2 instance that I need to change?
Like some inbound request via port 22 (instead of 3306).

New to Knime, new to working with AWS EC2.
Any help will be deeply appreciated. I have been at it for the past 2 days.

[quaeler]

Hi and welcome -

EC2 instances, by default, have a very strict firewall policy (what ports are able to be reached from the outside.)

From your instance console page, find the section describing the security policy:

and click on the security policy name; then change to the inbound rules and add a rule that opens up your 3306 port (not opened here, just showing the page):