Access issues for MySQL database when Taking over data flow

Hi k_foxy 
Thank you for reaching out microsoft fabric community forum.

Thanks for the details and the log — this is a known issue where the “Take Over” action can break the connection by removing or not transferring the saved credentials, especially with VNet Gateways and non-SSL MySQL sources.

Since your server doesn’t support SSL, setting the encryption to "Encrypted" won’t work. Instead, after taking over the dataflow, try deleting and recreating the MySQL connection, making sure to set the encryption to “Not Encrypted.” Then rebind the dataflow to this new connection.

Also, check that the VNet Gateway allows non-SSL connections, as it may default to requiring encryption even if the connection says otherwise.

This usually resolves the issue, as the problem stems from credentials being tied to the original owner.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.