Etl mysql connection failed

Neo4j Graph Platform ETL-Tool
1

I cannot create a connection between Mysql and Neoj4 using ETL. I get following error message "Connection failed. SQL state: 08001, message: Could not create connection to database server. Attempted reconnect 3 times. Giving up". Capture

2

you have no password in your mysql db?
is it up and running? can you connect from the mysql console?
and via JDBC, e.g. via squirrelsql?

3

I have a db password which I provide but it still happens. These are the details of my db:
username = root
password = password

With the same details I am able to connect via JDBC using these details:

#spring.datasource.Driver =
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/projectdb
spring.datasource.username = root
spring.datasource.password = password
spring.jpa.show-sql=true

Note! the databases are two mydb and projectdb, I face the same challenge in trying to create the connection, be it mydb or projectdb, I get the same feedback.

4

I'm not an expert but i think you should check your database input, try to put as it is in your mysql :thinking:

5

perhaps a localhost lookup issue?

did you try to paste the exact URL you use in Spring into the app?

jdbc:mysql://127.0.0.1:3306/projectdb

6

Yes I did that. I am still facing the same problem, and thinking maybe some windows files could be the cause of this, I did a new windows installation and installed only MySQL Workbench and Neo4J desktop. I went through the required configuration and had my ETL tool installed. Low and behold it gave me the same message. Maybe something further is required beyond the ETL integration video I watched online.
What configuration do I need from MySQL Workbench ? or what windows configuration do I need. Thanks

7

You just need the mysql database running and being able to accept connections
And have the auth set up and a database created to access.

Can you try to connect to it using JDBC e.g. with Squirrel or SQLExplorer?

8

I have been able to connect using SQL Explorer.

Capture2
Capture2.JPG1366×726 133 KB
. I decided to copy the url from the configuration in SQL Explorer Capture3 to Neo4j ETL.

9

And this is the message that appears

Capture
Capture.JPG1057×594 37.5 KB
. Meanwhile going by the default configuration in Neo4j ETL, I still encounter the same problem "Connection failed. SQL state: 08001, message: Could not create connection to database server. Attempted reconnect 3 times. Giving up."Capture4 .

10

Hi, does your connection use SSL or not?
What version of MySQL are you using? Is it 8.x?
Because probably the embedded driver doesn't support MySQL version 8.x.
I have to check which embedded version the ETL tool is currently using.

Thanks

12

The version of MySQL I'm using is 8.0.

13

Then please use a custom driver and select "JDBC" in the drop down box and construct your own JDBC URL.

14

This worked - jdbc path - thanks Micjeal