Forum Discussion
DataSource.Error: MySQL: Host is blocked because of many connection errors
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.
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