Re: MySQL gives this IO error, please help
Posted by: Steven Tillson
Date: July 23, 2021 01:02AM

This is really aggravating. I contacted PowerBI support, but they were unable to assist me. Points to remember:


Trying to connect to a MySQL database that is encrypted using SSL.

Earlier in the year, this worked.


Something changed (I'm not sure what) and now whenever I try to get in, I receive an authentication issue.


Things I've tried include:

PowerBI reinstallation

MySQL Connector versions 8.0.14,.15, 16,.17, and.18 are installed.

Using a different computer

Adding certificates to the certificate store on the computer (Personal, Truster Root, Third party)

Taking everything apart and beginning over


To verify it's related to the certs, I requested the DB admin to delete them, which allowed me to join using username and password alone right away.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL gives this IO error, please help
July 23, 2021 01:02AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.