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.