Cannot connect to local MySQL database.

[sois]

Hi All, I press get data and select MySQL datatabase. 

I get the following message:

"we encountered an error while trying to connect. the connector cannot be used because you are missing one or more required components.".

The Learn More link took me to the MySQL site to download 

mysql-connector-net-6.6.5.msi.

I downloaded that and nothing happened. I restarted my machine as well, no dice.

Windows 10, 32 bit office, 32 bit power BI.

Thank you.

[MAAbdullah_47]

Hi I have the same problem I tried many times nothing still been solved, please advice.

[Abdulazeez_tayo]

Have you been able to resolve it 😪

[nerymuxson]

You can try this solution, it worked for me.

Link: https://youtu.be/9h7MYoxQO6M

[Anubha]

I tried to connect power Bi with both 32 bit and 64 bit MySql connector . but non of them worked ,everytime getting an error that "this connector require one or more component" . 

Any help will be highly appreciated.

Thanks

[Stulle2612]

my current MySQL installation (5.7.19) installed the Connector/NET 6.9.9; this produced the wellknown error.

Solution:

1. using MySQLInstaller and uninstall the Connector/NET
2. download version 6.6.7 from MySQL
   • click Looking for previous GA versions? on the right 
   • select version 6.6.7 (the only available 6.6.x release)
   • download the MSI installer(mysql-connector-net-6.6.7.msi)
3. doubleclick the downloaded MSI-file for installing it
4. any type of restart needed ? I don't know/remember

 Hope this discription helps

[ankitpatira · Accepted solution]

@sois Ignore that link and instead download x64 bit MySQL connector and install yourself. I have seen before where doing that has fixed the problem.

[sau6402]

@ankitpatira - Can you please share the x64 dowload link you are referring to. I installed x64 from this link but no success [I think we need .NET connector and not ODBC. I was unable to find .NET x64]

[ovetteabejuela]

 @sois / @ankitpatira

Can you please share the link for the x64 version that works? Thank you.

[fff]

Getting same error.  "this connector requires one or more additional components to be installed"

Have installed .net mysql connector 32bit.  Can't find a 64bit version anywhere.

[kt2017]

I downloaded the mysql connector from next url:

https://dev.mysql.com/downloads/connector/odbc/

Please select for windows and 64 bit.

It works for me.

[Anonymous]

 please after installing the connector what needs to be done?

[rskaskiw]

It turns out that the version is of the MySQL connector is very important.  I wasted a lot of time trying to figure out why earlier versions -- some of them linked to in forums -- did not work.

[milad_bahari]

For me this version only works, the new versions do not work at all

[fff]

same problem. mysql doesn't offer 64bit .net connector and 32bit doesn't work with powerbi

getting: "this connector requires one or more additional components to be installed"

[rsmhema1993]

@ankitpatira can you plz share that link windows x64 connector? couldn't able to find that link...

[sois]

Perfect, thank you! I just downloaded the latest version and restarted  the app. It works now!