hi everyone!
I can’t connect to database using the node “MySQL Connector”. But I can do it with other softwares such as “Navicat”、“SQLyog” . The connection settings are correct.
the error message: ERROR MySQL Connector 3:1 Execute failed: Communications link failure
The last packet successfully received from the server was 2 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
Hi @vzzw,
Do you have a proxy configured in your operating system by any chance? This might affect the connection and can be set up for KNIME in Preferences → General → Network Connections.
Kind regards,
Alexander
Hi @AlexanderFillbrunn ，thank you very much!
I don’t have any proxy. The operating system is WIN10. KNIME settings as shown below:
Hi @vzzw,
Have you had a look at the options listed here? From that it looks like the error is either caused by a setting in MySQL or a proxy or firewall configuration. We had one user before, where the company for some reason blocked network requests only from Java programs, which KNIME also is.
In the screenshot you provided, KNIME is configured to use the proxy configured in your operating system. If you really have none there, I suggest switching the proxy settings to “Direct”. Does that yield the same results with the MySQL Connector?
Kind regards,
Alexander
2 Likes
I‘ll try again，Thank you very much!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.