Question
The connector is failing with the following error:
Aborted connection XXX to db: 'unconnected'
user: 'fivetran' host: X.X.X.X (init_connect command failed)?
Environment
Connector: MySQL
Answer
init_connect is a server-side parameter that forces the execution of one or several SQL statements upon a user's connection to the server.
The connector is failing as the fivetran user does not have the appropriate permissions to execute these statements.
In order to resolve the issue, you will need to:
- Identify which statements are being run.
- Grant the appropriate permissions for the user to be able to run all of them.