Forum Discussion
Solved
Real Time Intelligence Connection issue with MySQL DB CDC
We have set up an on-premises data gateway to connect AWS RDS MySQL within a VPC. Using this gateway, we successfully fetch data from Fabric Data Factory pipelines, and the connection is working as e...
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 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.