Description
The following error might be observed on the Confluent Cloud UI for MySQL Source/Sink Connectors:
The connection to MySQL server timed out. Please make sure an instance of MySQL is running on the host and accepting TCP/IP connections at the specified port.
Applies To
Confluent Cloud
MySQL Source Connector
MySQL Sink Connector
Cause
This error message indicates the connector is not able to connect to the specified MySQL database instance.
Resolution
- Ensure that the MySQL database is up and running and ready to accept the connections.
- If a firewall is enabled on the MySQL database system level or at the Cloud provider level that is hosting the database, you will have to whitelist a set of IPs to allow connectivity. These IPs can differ based on the Confluent Cloud Network Type selected. Please review the documentation here and here to determine the IP address ranges to be whitelisted based on your environment.
- Check your network to see if there is a proxy/load balancer between your connector and your MYSQL database instance that would interrupt connection requests.