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-...
duggy's avatar
duggy
Icon for Advocate II rankAdvocate II
7 years ago

Hi,

 

Has anyone found  decent solution for this problem? From a security perspective it isnt recommended to have too many max_conect_errors. The way around is to set up a scheduled task to flush, but again seems to be a patch then a fix. Any recommendations? Possibly a different more resilient gateway?

jmcclure's avatar
jmcclure
Frequent Visitor
7 years ago

Hi Everyone, 

 

I am about 3 weeks into setting up an Executive deployment of Power BI, and the Data Gateway bug to MySQL is absolutely going to kill this project.   I was amazed to see how long this issue has been reported, yet not addressed.  It seems the data gateway is in a perpetual state of Beta testing.

 

It has been 2 years now Microsoft - what is the deal with getting this fixed?  It should be relatively easy.  Please debug the unauthenticated user issue asap or you will continue losing the business of everyone who keeps data warehouses in MySQL.