Cannot create eventstream from MySQL

Hi linardskalvanse ,

According to the screenshot you provided, your Eventstream was created successfully but the data source connection failed. That should be a problem on your MySQL DB side.
First, please check your computer's firewall or other protective software to make sure that your MySQL is not behind a firewall and is publicly accessible.
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/add-source-mysql-database-change-data-capture#prerequisites 

If you are the admin user of the MySQL, you can directly use the admin user to connect to the database which normally has the appropriate privileges already as below. But if you're not the admin user, you must define a MySQL user with appropriate privileges on all databases where the Messaging Connector can capture the changes from.

mysql> CREATE USER 'user'@'%' IDENTIFIED BY 'password';
mysql> GRANT SELECT, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'user'@'%';
mysql> FLUSH PRIVILEGES;
SHOW GRANTS FOR user;

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/add-source-mysql-database-change-data-capture#set-up-mysql-db 

The documentation link you provided also mentions that You must enable binary logging for MySQL replication.
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/add-source-mysql-database-change-data-capture#enable-the-binlog 

Please make sure that you have configured the above three points correctly.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.