cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Unable to Connect to MySQL database

I tried to connect to MySQL database. It gives the following error. Any help please?

 

When I select to SQL

Error Screenshot.JPG

 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106' or one of its dependencies. The system cannot find the file specified.'"

35 REPLIES 35
Highlighted
Advocate I
Advocate I

I had the same problem with 8.0.17. I uninstalled it, and installed 8.0.16 from here: https://mirrors.dotsrc.org/mysql/Downloads/Connector-Net/ . Error went away. 

Highlighted

problem is gone. 

Thanks

Highlighted

HI @trenthord ,

 

Thanks for that information, error went away.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted

Hi @trenthord ,

 

I am getting some different error while connecting to MySQL workbench database. Please guide me to remove this error.

 

ERROR:--    "MySQL: Fatal error encountered during data read."

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted

@trenthord  Thanks It works 🙂

Highlighted

@Tahreem24 You may need to click on the "Show Details" button to see the specific error message. 

Highlighted

Same issue. Also solved with 8.0.16. Thanks 🙂

Highlighted
New Member

Hello,

 

I have fixed that issue by using an older version fo the mysql-connector...

Here a link that I will share for some time: mysql-connector-net-8.0.12 (x64)

Hope that will help some of you 🙂

 

pH

Highlighted

I had the same problem, but it emerged from wanting to install the latest version of the Mysql Connector (mysql-connector-net-8.0.17).

 

Once installed, the problem started.

 

I rolled back to the previous version of the connector that I had installed (mysql-connector-net-6.10.8).

 

Problem solved.

Highlighted

I had the same problem with 8.0.17. I uninstalled it, and installed 8.0.16.  No Errors.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors