TAC Database connection to MySQL 5.7 fails

Problem Description

Using MySQL5.7 with Talend 6.5.1 or Talend 6.4.1 results in the following error:

Cannot connect to database (null, message from server: "Host 'Hostname' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")

 

Solution

The issue is not related to the JDBC driver being used. The following drivers were tried, but all resulted in the same error.

mysql-connector-java-5.1.23-bin.jar
mysql-connector-java-5.1.45-bin.jar
mysql-connector-java-5.1.46-bin.jar

 

The resolution is to edit the JDBC URL for the TAC database in Database Parameters, as shown below:

 

Original JDBC Path

jdbc:mysql://hostname:3306/tac651

 

Modified JDBC Path

jdbc:mysql://hostname:3306/tac651?autoReconnect=true&useSSL=false

Modified_Parameters.JPG

Version history
Revision #:
3 of 3
Last update:
‎05-08-2018 12:20 PM
Updated by:
 
Contributors