View original (French)

Create a new MySQL connection

Solved
Maximims Posted messages 275 Status Membre -  
Takine Posted messages 1 Status Membre -
Hello,

I have a small issue with MySQL software.

Let me explain briefly, I would like to import data from a database on Microsoft SQL Server into my database created on MySQL.
To do this, I am using Talend, so I created a job to retrieve the data from one database to transfer it to another.

However, from MySQL, I am trying to create a new connection (via Workbench) but this error message appears: "can't connect to MySQL server on '127.0.0.1' (10061)".

I am really a beginner in this matter, I think I am confusing several terms and concepts because I am completely lost.

Thank you in advance for your help if anyone passes by here!

1 réponse

Réponse 1 / 1
jordane45 Posted messages 30426 Registration date   Status Modérateur Last intervention   4 830
 
Hello,

Is your MySQL database on your computer?
What did you use to install it?
Is it running properly?
Do you know the login credentials?
Is the port you specified for the connection the default one for MySQL? (3306)?

--
Best regards,
Jordane
2
Maximims Posted messages 275 Status Membre 68
 
Actually, I initially thought I'd make the connection before creating the database..
The problem is that I don't have a database on MySQL; I thought I had created the database by creating a new model on Workbench.
0
jordane45 Posted messages 30426 Registration date   Status Modérateur Last intervention   4 830
 
Arf...
Are you the kind of person who puts gas in... before having a car?

No... workbench is just an interface that allows you to feed/manipulate databases...
To be able to create a connection... you need something to connect to.
So, you first need to install mysql on your computer... then create a Database and finally you will be able to connect to it.

To have a local mysql database on your computer... you can download software like Laragon, Uwamp, Xampp, Wamp, EasyPhp... it's up to you to choose...
0
Maximims Posted messages 275 Status Membre 68
 
Thank you, it's much clearer for me now! I have downloaded MySQL (for real this time..) After creating my database on MySQL Command Line Client, the connection via Workbench worked!

Now on Talend, the connection still works, but the one corresponding to my MySQL database displays an error message which is as follows:

"Connection failed. You need to modify the database settings.
java.lang.RuntimeException: java.sql.SQLException: The server time zone value 'Paris, Madrid' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support."

It seems to me that this is related to a time zone issue, but downloading the specified driver did not solve it..
0
Maximims Posted messages 275 Status Membre 68
 
I finally found the answer to my question, I simply changed the conditions to this:

jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
0
jordane45 Posted messages 30426 Registration date   Status Modérateur Last intervention   4 830 > Maximims Posted messages 275 Status Membre
 
According to the error message... it comes from the driver configuration

The message tells you to configure the server and/or the driver.
On the server side:
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

On the driver side... no idea. It is no longer a MySQL issue per se... but your software.
0