Connecting to mysql using nifi

[#1]

Hi,

I'm trying to connect to nifi from mysql, so while connecting i'm facing some poolable connection error like

My client nifi is set up on docker and mysql is on host that is local.

I can see sql workbench able to connect to mysql on 127.0.0.1 and 3306 so it means port is opened.

But looking the below error suggest that there is some problem connecting to mysql

Any help on this would be appreciated

[#2]

@Shu If you can have a look too

[#3]

@Vaibhav Kumar

Make sure you are using correct mysql jdbc jar and check the connectivity between docker nifi instance,Local mysql.

Please refer to the below links that having solutions for same exact issue,

https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysq...

https://serverfault.com/questions/89955/unable-to-connect-to-mysql-through-jdbc-connector-through-to...

[#4]

@shu tried almost all the thing mentioned above but still no luck