Confluence MySQL connector connection not established

Question

I'm trying to connect to MySQL DB (installed in my laptop) from Confluence Cloud Remote access using the MySQL Source connector. I cannot connect to the MySQL Connector.

Error: Unable to verify configuration. if right configuration, which means the configuration is invalid, and The connector continues to run on the previously passed configuration verify. mistake:

Connection.Password: Unable to connect to database

table.whitelist: Unable to check if table exists due to connection error

The same JDBC connection works through a Java program on my laptop.

Sample program I used:

try {
    // connect way #1
    String url1 = "jdbc:mysql://192.168.2**.**:3306/test_kafka_connectors";
    String user = "Adhi";
    String password = "*****";

    conn1 = DriverManager.getConnection(url1, user, password);
    if (conn1 != null) {
        System.out.println("Connected to the database test1");
    }

Hostname (localhost with port 3306 or 192.168.2**.**:3306 (my laptop IP address)) works fine in Java programs.

Using the Confluence connector, I cannot establish a connection. Steps I completed below

step 1. I have added connection string details along with username and password inside the connector.

Authentication

Connect to host\

192.168.2**.2**

Connection port

3306

Connect user

Adi

Connection password

******************

Name database

test_kafka_connectors

SSL mode

prefer

Step 2. Create a user (Adhi, IP address is Confluence) in MySQL below and grant permissions. Please refer to the database user picture.

Step 3: I tried putting the bind address attribute of the Confluence IP address into the MySQLconf file mysqlrouter.conf and restarting the mysql service, but the Connector connection still doesn't work.

Answer 1

192.168.2**.2** is the LAN subnet on your home network. You need to use the public IP provided by your ISP. You will also need to forward port 3306 through your router.

---

Not sure why you "need" Confluence Cloud. You should be able to run the Kafka Connect JDBC connector (and Kafka) with MySQL on your local machine.