cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
webportal
Impactful Individual
Impactful Individual

MySQL: Unable to connect to any of the specified MySQL hosts.

Hello,

 

I have a pbix connected a MySQL database that has always worked, until now.

 

Now, I get the error:

 

MySQL: Unable to connect to any of the specified MySQL hosts.

 

So, I have updated the MySQL Driver from: https://dev.mysql.com/downloads/connector/odbc/

 

Windows 10, Power BI Desktop are both 64 bits.

 

Anyone can help?

 

Thanks in advance!

1 ACCEPTED SOLUTION
webportal
Impactful Individual
Impactful Individual

Hi,

 

I happened to have an IP address changed that I hadn't noticed... 🤐

 

Sorry for keeping you busy and thanks for your support anyway!

View solution in original post

3 REPLIES 3
webportal
Impactful Individual
Impactful Individual

Hi,

 

I happened to have an IP address changed that I hadn't noticed... 🤐

 

Sorry for keeping you busy and thanks for your support anyway!

View solution in original post

v-kkf-msft
Community Support
Community Support

Hi @webportal ,

 

Perhaps you could try clearing the data source credentials in Desktop and re-entering them. Use the latest version 2.97.861.0 of Desktop. Or refer to this thread to use the previous version of the connector.

 


If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

@webportal , from the same system, are you able to connect to MySQL using MySQL browser.

In not, this issue with credential and IP whitelisting

 

If yes, this can driver issue.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!