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

[webportal]

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!

[webportal · Accepted solution]

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!

[v-kkf-msft]

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]

@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.