Forum Discussion
DataSource.Error: MySQL: Host is blocked because of many connection errors
I'm trying to connect to Power BI and receiving the following error. DataSource.Error: MySQL: Host 'xxx.xx.xxx.xx' is blocked because of many connection errors; unblock with 'mysqladmin flush-...
Hi John, Thanks for the fast reply.
We are also on MYSQL 5.5.60
Maybe thats the reason because as you say it should be affecting more people.
Maybe I need to see if there is an older SQL Connector which would be more stable. Sadly i cannot upgrade.
I logged a call with Microsoft and they spent 2 hours changing settings and gateways, but in the end no solution... Would be great to see if upgrading to SQL 8.0 fixes the issue.
I had the same issue for a very long time now and (in my case) it turned out, that I had to update my MySQL connector. Everything used to work fine until (without my knowledge) one of our MySQL sources was updated. Since updating the connector everything okay again.