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-...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

In this case as previously posted in the thread, you should ask your admins to run the mysqladmin flush-hosts command from the MySQL administration shell. If the problem persists you can try asking them to increase the max_connect_errors variable for that MySQL instance.

I'm kind of repeating what Eric_Zhang already said, but hopefully this is clearer.

JonnaGalloway's avatar
JonnaGalloway
Regular Visitor
9 years ago

Hi,

 

Apologies i must have missed that. I tried both solutions there, the first one briefly showed as 'connected' on Power BI online, but immediatly gave me the error on data refresh. Same error as previous.

 

I've uninstalled the gateway and on re-install, you get a big message saying: "A Gateway acts as a bridge between on-premises data (not in the cloud), and Power BI, PowerApps, Logic Apps, and Microsoft Flow."

 

A little contrasting to the support documents online saying it connects to MySQL, but by the sounds of it - not any cloud MySQL?

 

Thank you

  • 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

  • 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