Forum Discussion
Solved
Cannot connect to local MySQL database.
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 ...
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.
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
my current MySQL installation (5.7.19) installed the Connector/NET 6.9.9; this produced the wellknown error.
Solution:
- using MySQLInstaller and uninstall the Connector/NET
- 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)
- doubleclick the downloaded MSI-file for installing it
- any type of restart needed ? I don't know/remember
Hope this discription helps