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-...
jmcclure's avatar
jmcclure
Frequent Visitor
7 years ago

Hi Andrew, 

 

We went ahead and throttled up our max_error_connects.... and its very much not ideal. 

 

Out of curiosity what MySQL version are you running?  I am starting to wonder if this is a legacy MySQL version problem in particular, as I would expect there to be more people experiencing this issue given the pervasive use of MySQL for data warehousing. 

 

My organization is (painfully) still on MySQL 5.5.  We are upgrading to 8.0 in the next two weeks, afterwhich ill check back here to let you know if upgrading was a solution in any way. 

 

Good luck to you, and hopefully we hear from MS soon :/.

 

Best, 

John Mc.

andrew_adcock's avatar
andrew_adcock
New Member
7 years ago

Hi John, Thanks for the fast reply.

We are also on MYSQL 5.5.60

Maybe thats the reason because as you say it should be affecting more people. 

Maybe I need to see if there is an older SQL Connector which would be more stable. Sadly i cannot upgrade. 

 

I logged a call with Microsoft and they spent 2 hours changing settings and gateways, but in the end no solution... Would be great to see if upgrading to SQL 8.0 fixes the issue.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I had the same issue for a very long time now and (in my case) it turned out, that I had to update my MySQL connector. Everything used to work fine until (without my knowledge) one of our MySQL sources was updated. Since updating the connector everything okay again.