Can I Connect to Multiple Databases on the Same Server?

Question

I added a second database to the MySQL Server that is connected to Fivetran. However, the tables from this database are not appearing in the connector schema. Can I connect to multiple databases on the same server?

Environment

Connector: MySQL

Answer

You need to create a new connector to connect to the second database. You must add a different user for connecting to your second database to prevent the connectors from terminating each other's connection. For more information, see our MySQL setup guide.

Cause

Each database on a server has its own Replica ID.