Real Time Intelligence Connection issue with MySQL DB CDC

Hi Parthiban006 

Thank you for reaching out to Microsoft Fabric Community.

Below steps might help in resolving the issue :

• Go to the CDC connector settings in Real-Time Hub and explicitly enter the username and password, even if the connection was previously set up.
• Ensure that the on-premises data gateway is correctly configured and that Real-Time Hub is using the right connection.
• If using a connection string, verify that the username is correctly formatted (ex: user=root or UID=root).
• MySQL user must have REPLICATION SLAVE and REPLICATION CLIENT permissions for CDC to work.
• If the issue persists, review the logs to see if there are any additional authentication failures.

After applying these steps, retry the connection and see if it resolves the issue.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!