Forum Discussion
DataSource.Error: MySQL: Host is blocked because of many connection errors
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.
jmcclure I was just wondering if you had any luck switching to MySQL 8.0. I have been having this issue for some time now with MySQL 5.5 and nothing has worked! Thanks!
andrew_adcock did changing your connector to an older version help at all? I would prefer not to do this but will do so if it's the only solution. Thanks!