Migration from OnPrem MySql DataBase to Fabric

[PrathibhaC99]

Migration issue

Hi Team,

I am trying to migrate Mysql Database-Tables to Fabric but continuously experiencing error inspite of repeated attempts

Screenshot attached for your reference 

Error message - An exception occurred: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

Kindly guide me to resolve this issue

Thank you

[v-hashadapu]

Hi @PrathibhaC99 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

[v-hashadapu]

Hi @PrathibhaC99 , Hope you are doing well. Kindly let us know if the issue has been resolved or if further assistance is needed. Your input could be helpful to others in the community.

[PrathibhaC99]

Hi 

I could not resolve the issue as installed mysql but stuck at root password verificaton stage it is not heading further 

[v-hashadapu]

Hi @PrathibhaC99 , Thank you for reaching out to the Microsoft Community Forum.

Completely remove the old, partially installed MySQL instance and do a clean reinstall. Stop the MySQL service if it exists, uninstall MySQL Server and MySQL Installer from Windows Apps & Features, then delete the MySQL data directory. After that, rerun the installer, this time it will let you set a new root password instead of forcing you to verify an old one.

Once MySQL installs cleanly and fully, you can install Connector/NET on the same gateway machine, restart the gateway and then retry the Fabric connection. The Fabric error you originally saw won’t go away until MySQL and the MySQL provider are both set up cleanly, so fixing the installer issue is the right next step.

[tayloramy]

Hi @PrathibhaC99, 

localhost won't work in Fabric as localhost references your machine. 

If you want this to be useable from your local machine, you need a data gateway. YOu can install a personal gateway on your computer for a one time transfer, but if you want repeated transfers, you should get a server with a standard gateway. 

For more info, see Install an on-premises data gateway | Microsoft Learn

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[PrathibhaC99]

Thank you for replying

I did try your solution before posting my query but the issue remains.

[v-hashadapu]

Hi @PrathibhaC99 , Thank you for reaching out to the Microsoft Community Forum.

The gateway machine is either missing Connector/NET, has the wrong bitness or .NET runtime for the provider or the provider isn’t registered for the .NET runtime the gateway uses. Install the matching MySQL Connector/NET (use the 64-bit installer if your gateway is 64-bit), then restart the gateway service so it picks up the provider. Don’t use localhost unless the gateway runs on the MySQL server itself, the server name must be reachable by the gateway (hostname or IP) and port 3306 must be open

to the gateway host.

Quick verification to run on the gateway box in PowerShell:

try { [System.Data.Common.DbProviderFactories]::GetFactory("MySql.Data.MySqlClient"); "Provider found" } catch { "Missing: $($_.Exception.Message)" }

If it returns Missing…, reinstall (or try a different version of) Connector/NET, then restart the gateway and re-run the test. If the provider shows as present but Fabric still fails, check the gateway logs and Windows Event Viewer for assembly binding or permission errors and make sure the gateway service account can read machine-level .NET config.

[edwinter]

@PrathibhaC99 ,

You may want to check your MySQL Installer version, some users report a bug in some versions that result in this exact error.

Check this thread for more details:
Cannot find a database provider with the invariant name MySql.Data.MySqlClient - Power Apps - Stack ...

[PrathibhaC99]

Thank you for replying will check