Error: Aborted Connection to DB

Issue

The connector is failing with the following error:

Aborted connection to db: 'unconnected' user: 'fivetran' host: (init_connect command failed)

Environment

Connector: MySQL

Resolution

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.

You need to identify which statements are being run and grant the appropriate permissions for the user to be able to run all of these statements.

Cause

The connector is failing as the fivetran user does not have the appropriate permissions to execute these statements.