Etl mysql connection failed

[strato_bayitaa]

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".

[michael_hunger]

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?

[strato_bayitaa]

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.

[mojtaba_tmj]

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

[michael_hunger]

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

[strato_bayitaa]

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

[michael_hunger]

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?

[strato_bayitaa]

I have been able to connect using SQL Explorer.

. I decided to copy the url from the configuration in SQL Explorer to Neo4j ETL.

[strato_bayitaa]

And this is the message that appears

. 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." .

[albertodelazzar]

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

[strato_bayitaa]

The version of MySQL I'm using is 8.0.

[michael_hunger · Accepted solution]

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

[davidrsetti]

This worked - jdbc path - thanks Micjeal