cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andre3s
Regular Visitor

Re: Unable to Connect to MySQL database

Hi,

 

I solved this problem by uninstalling the latest version of MySQL Connector (8.0.17) and installing the 8.0.15. I followed this video : https://www.youtube.com/watch?v=VC9h7yVRHV8

 

And this is the link to download the version 8.0.15 : https://downloads.mysql.com/archives/c-net/

 

Good luck you all.

Cucharilla
Frequent Visitor

Re: Unable to Connect to MySQL database

Aaah I feel like I'm going a little crazy. So I followed the advice below and donwgraded to an earlier Connector version (8.016 I think) and it cleared this error and I was able to connect fine for a few weeks. I was recently experimenting with another BI tool and needed 8.0.17 so upgraded again. To use PowerBI I downgraded again this week and now whenever I try to connect I just get 'We couldn't authenticate with the credentials provided' message. I've tried 8.0.15, 8.0.16, different user names and passwords and still have the same. Credentials are fine as when I connect via MySQL Workbench it connects okay. Any ideas?

SureshPantra Helper II
Helper II

Re: Unable to Connect to MySQL database

Hi,

Am using the sqlconnector 8.0.16 but still am facing the same error , could you please help ASAP.

 

Regards,

Suresh .

RobThrive Helper II
Helper II

Re: Unable to Connect to MySQL database

Hi @SureshPantra, as everyone has been starting throughout the thread, please install 8.0.15 !
I have just done it 2 minutes ago and it has worked for me.
astclair
New Member

Re: Unable to Connect to MySQL database

Highlighted
Cucharilla
Frequent Visitor

Re: Unable to Connect to MySQL database - SSL issues

This is so frustrating. I've spoken to PowerBI support and they couldn't help either. Main points:

 

Trying to connect to MySQL DB secured via SSL

This worked earlier in the year

 

Something changed (no idea what) and now I get an authenticartion error whenever I click login.

 

Things I've tried:

Reinstalling PowerBI

Installing versions 8.0.14, .15. 16 .17 and .18 of MySQL Connector

Using another computer

Adding certs to the computer cert store (Personal, Truster Root, Third party)

Removing everything and starting again

 

To prove it is something to do with the certs I've also asked the DB admin to remove them and this allowed me to connects immediately using username and password only

 

To prove the certs are okay I can connect to the DB from my maching using MySQL workbench. Interestingly you actully point to the cert pem files in the Workbench login screen. I also spoke to Tableau about this and their support were able to help me connect using the same certs with no issues.

 

Please, please, please can someone help. 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors