Cannot Connect Power BI to Local MySQL Workbench Server

[jayjay144]

Hi,

I am trying to import SQL server data into Power BI. I am using a local instance of MySQL Workbench to do so.

I am able to put in the server and database just fine, but when I input my credentials I get the error message" 'Internal connection fatal error. Error state: 18'

I have been trying for 2 days to connect. I have tried downloading the .NET connector driver twice, the ODBC connector with a complete install, ensuring I have mysqld.exe installed. I have tried not connecting to root and creating a new user, this still gives me an error message, although different-see attached.

I have watched every single youtube video on this topic and read every blog post, still nothing. 

Any help at all? I am at my wits end here. Connecting using rootError connecting with a new userError connecting using root

[lbendlin]

1. do not use "localhost". Use a fully qualified domain name (FQDN).  You will need a gateway, and that gateway has no idea what "localhost" means

2. uninstall your current Net connector and install version 8.0.28 - it is one of the few versions known to actually work.

[jayjay144]

The solution was using another Net connector version. Connecting to Localhost works however. 

[v-veshwara-msft]

Hi @jayjay144 ,
Thanks for engaging with Microsoft Fabric Community,
Also thanks for confirming that using another .NET connector version resolved your issue.
Would you mind marking the helpful reply as "Accepted Solution" to help others facing similar issue find the solution quickly.
Thanks @lbendlin for your valuable contribution to the community.