I am having trouble using the ETL Tool to connect from my laptop at home to the MySQL database on my remote hosted linux server. When I get to the point of adding the connection, I get the error:
"Connection failed. SQL state: 08001, message: Could not create connection to database server. Attempted reconnect 3 times. Giving up."
(See screenshot below.)
From what I can find online, this error could indicate a mismatch between my MySQL database server version and the MySQL JDBC jar file version. I know the MySQL server version but I'm not sure how to find the JDBC jar file version. To be honest I'm not even sure if the JDBC driver is supposed to reside on my laptop or my remote linux server -- I think my laptop (is it bundled up with the ETL Tool??) but I'm not sure.
I am using:
Neo4j Desktop 1.2.3 running on my MacBookPro at home; I'm able to use Neo4j Desktop successfully for other applications like manipulate and visualize my local graph database.
Neo4j ETL Tool 1.4.2
The remote MySQL database runs on a linux (redhat) server.
MySQL server version is 10.2.27-MariaDB.
Things I've done: I've made sure to whitelist my local IP address via the 'Remote MySQL' page in cPanel.
So my first probably very dumb question: how do I find out my JDBC jar file version?