Error when Data Pipeline tries to connect to MySQL 8:
amazonaws.datapipeline.database.ConnectionFactory: Unable to establish connection to jdbc:mysql://<host> Could not create connection to database server.
Caused by: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
Connector/J" that is installed by AWS Data Pipeline does not work. You will need to replace it by adding your own external JDBC driver
Prerequisites for the new data pipeline
The MySQL JDBC driver "Connector/J" that is installed does not work.
You will need to download the correct version from Oracle.
Select Platform Independent
Download the .tar.gz file to your local machine.