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'")
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: