Question
While setting up a MySQL connector, the connection fails with the following error:
Unable to validate database user
Test failed with "java.lang.RuntimeException:
java.lang.RuntimeException:
com.fivetrann.lambda.Retrier$RetrierException: The action failed after 1 attempt(s), the failures were:
1) java.lang.RuntimeException:
java.util.concurrent.ExecutionException:
java.lang.RuntimeException:
java.sql.SQLNonTransientConnectionException:
CLIENT_PLUGIN_AUTH is required ".
Environment
Connector: MySQL
Resolution
Please update your MySQL database to any version in the range of 5.5-8.0.
Cause
The JDBC driver that Fivetran uses to connect to MySQL databases is not compatible with MySQL versions lower than 5.5.