Forum Discussion

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

Not applicable

9 years ago

So what error message, exactly, are you receiving?

Regular Visitor

9 years ago

Ok doki, just took a screenshot below:

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
  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
  - viera00
    Helper 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