[source-mysql] SSL not working with CDC mode

### Connector Name

source-mysql

### Connector Version

3.51.6

### What step the error happened?

During the sync

### Relevant information

**Environnement**
- Airbyte version: 2.0.1
- Deployment: local Docker
- Source Connector and version: source-mysql/3.51.6
- Host version : MySQL 8.0.18-google

**Connector Configuration**
- SSL mode : verify_ca,
- Update Method : Read Changes using Binary Log (CDC)
- Certificates : server-ca.pem, client-key.pem, client-cert.pem

**Issue**
During sync, with mode set to "Incremental | Append + Deduped", we get the following error message :

```
2026-05-06 16:31:26 error May 06, 2026 2:31:26 PM com.github.shyiko.mysql.binlog.BinaryLogClient resolveDatabaseVersion
2026-05-06 16:31:26 error INFO: Database version: 8.0.18-google (major=8, minor=0, mariadb=false)
2026-05-06 16:31:26 error May 06, 2026 2:31:26 PM com.github.shyiko.mysql.binlog.BinaryLogClient tryUpgradeToSSL
2026-05-06 16:31:26 error INFO: SSL enabled
2026-05-06 16:31:26 error ERROR debezium-mysqlconnector-h2ocbe-change-event-source-coordinator i.d.p.ErrorHandler(setProducerThrowable):52 Producer failure io.debezium.DebeziumException: Failed to authenticate to the database at XXX.XXX.XXX.XX.bc.googleusercontent.com:3306 with user 'XXX'
at io.debezium.connector.binlog.BinlogStreamingChangeEventSource.execute(BinlogStreamingChangeEventSource.java:328) ~[debezium-connector-binlog-3.1.2.Final.jar:3.1.2.Final]
at io.debezium.connector.binlog.BinlogStreamingChangeEventSource.execute(BinlogStreamingChangeEventSource.java:103) ~[debezium-connector-binlog-3.1.2.Final.jar:3.1.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:322) ~[debezium-core-3.1.2.Final.jar:3.1.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203) ~[debezium-core-3.1.2.Final.jar:3.1.2.Final]
at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143) ~[debezium-core-3.1.2.Final.jar:3.1.2.Final]
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.base/java.lang.Thread.run(Thread.java:1583) [?:?]
Caused by: com.github.shyiko.mysql.binlog.network.AuthenticationException: Access denied for user 'XXX'@'XXX.X.XXX.XXX' (using password: YES)
at com.github.shyiko.mysql.binlog.network.Authenticator.readResult(Authenticator.java:81) ~[mysql-binlog-connector-java-0.40.2.jar:0.40.2]
at com.github.shyiko.mysql.binlog.network.Authenticator.authenticate(Authenticator.java:66) ~[mysql-binlog-connector-java-0.40.2.jar:0.40.2]
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:600) ~[mysql-binlog-connector-java-0.40.2.jar:0.40.2]
at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:959) ~[mysql-binlog-connector-java-0.40.2.jar:0.40.2]
... 1 more
```

We double-checked our certificates, they appear to be valid. Connection and SQL commands work fine with DBeaver for example.
Also, sync works when using Update Method = Scan Changes with User Defined Cursor
Disabling SSL resolve the issue but it is not complient with our security policy
We were unable to reproduce the issue with MySQL connector v3.7.3

Thanks in advance

### Relevant log output

```shell

```

### Contribute

- [ ] Yes, I want to contribute

---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/12344