Forum Discussion
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!
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!
If we have a MySQL DB inside a private network we can't able to perform this operation as per the prerequisites in the documnet and attached the screenshot for your reference. Is there any alternate solution to acheive this?
Hi Parthiban006 ,
Yes, Real-Time Hub doesn’t support private network access. Here is one alternate solution.
Implement near real-time sync using high-frequency scheduled Copy Activities or Data Flows in Fabric Data Factory, leveraging a watermark column (like a timestamp or ID) to capture only the incremental changes.
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!