Forum Discussion

Hike_N's avatar
Hike_N
Regular Visitor
10 years ago

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-...
viera00's avatar
viera00
Icon for Helper II rankHelper II
9 years ago

Hi

 

I was not able to solve the problem (with the Enterprise Gateway) but i decided to uninstall it and use de "Personal Gateway". Now the refresh is working fine. The error stoped. Analyzing the traffic, it seams that the personal gateway "closes" the connection appropriatelly (and the enterprise gateway dont).

 

It is worth to try. Let me know if it worked for you.

 

Regards,

 

GV

JonnaGalloway's avatar
JonnaGalloway
Regular Visitor
9 years ago

Hi Viera,

 

Thanks for your response.

 

I got to the bottom of the problem so I best mark this complete.

 

Basically the MySQL is hosted through Go Daddy and the spec on data gateways (for automatic data refresh) if it's Microsoft Azure hosted MySQL - which is a massive shame.

 

On another note I had personal gateway set up to attempt to refresh this data from hosted MySQL, but I also had on-premise SQL data which uses the enterprise gateway and they were conflicting just like you said.

 

Thanks very much