https://community.fabric.microsoft.com/t5/Developer/Many-connection-errors/m-p/2096841#M32022 <P>Please help to resolve the below issue.</P><P><SPAN>MySQL: Host '00.0.0.00' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijay22kar_0-1632481612625.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/600359i3AE4511BEFA3D6B2/image-size/medium?v=v2&amp;px=400" role="button" title="vijay22kar_0-1632481612625.png" alt="vijay22kar_0-1632481612625.png" /></span></P><P>&nbsp;</P> Fri, 24 Sep 2021 11:08:00 GMT vijay22kar 2021-09-24T11:08:00Z https://community.fabric.microsoft.com/t5/Developer/Many-connection-errors/m-p/2096841#M32022 <P>Please help to resolve the below issue.</P><P><SPAN>MySQL: Host '00.0.0.00' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijay22kar_0-1632481612625.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/600359i3AE4511BEFA3D6B2/image-size/medium?v=v2&amp;px=400" role="button" title="vijay22kar_0-1632481612625.png" alt="vijay22kar_0-1632481612625.png" /></span></P><P>&nbsp;</P> Fri, 24 Sep 2021 11:08:00 GMT https://community.fabric.microsoft.com/t5/Developer/Many-connection-errors/m-p/2096841#M32022 vijay22kar 2021-09-24T11:08:00Z https://community.fabric.microsoft.com/t5/Developer/Many-connection-errors/m-p/2098991#M32056 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/121191">@vijay22kar</a>&nbsp;,</P> <P>I found some threads below that have the same error message as yours, please check the solution inside. Hope they can help you solve the problem as well.</P> <P><A href="https://stackoverflow.com/questions/22285318/how-to-unblock-with-mysqladmin-flush-hosts" target="_self"><STRONG>How to unblock with mysqladmin flush hosts</STRONG></A></P> <BLOCKQUOTE><HR /> <P><SPAN>Run the bash command in mysqladmin shell</SPAN></P> <P><CODE class="literal">flush-hosts</CODE></P> <HR /></BLOCKQUOTE> <P><A href="https://www.cyberciti.biz/faq/error-1129-hy000-host-is-blocked-because-of-many-connection-errors/" target="_self"><STRONG>Fix Host ‘IP’ is blocked because of many connection errors on MySQL/MariaDB</STRONG></A></P> <P><A href="https://tableplus.com/blog/2019/08/host-is-blocked-because-of-many-connection-errors.html" target="_self"><STRONG>Host is blocked because of many connection errors MySQL</STRONG></A></P> <BLOCKQUOTE><HR /> <P><STRONG>1. Verify the connection</STRONG></P> <P><STRONG>2. Increase the value of&nbsp;<CODE class="highlighter-rouge">max_connect_errors</CODE></STRONG></P> <P><STRONG>3. Flush host cache
<CODE class="highlighter-rouge"></CODE></STRONG></P> <HR /></BLOCKQUOTE> <P><STRONG><A href="https://community.powerbi.com/t5/Desktop/DataSource-Error-MySQL-Host-is-blocked-because-of-many/td-p/60965/page/3" target="_self">DataSource.Error: MySQL: Host is blocked because of many connection errors</A>&nbsp; </STRONG>(check the message <STRONG>29</STRONG> from @<STRONG>herbemischung</STRONG>)</P> <BLOCKQUOTE><HR /> <P><SPAN>1. Upgrade the version of on-premise gateway to the latest one</SPAN></P> <P><SPAN>2. Upgrade the version of MySQL connector to the latest one</SPAN></P> <HR /></BLOCKQUOTE> <P>Best Regards</P> Mon, 27 Sep 2021 02:23:27 GMT https://community.fabric.microsoft.com/t5/Developer/Many-connection-errors/m-p/2098991#M32056 Anonymous 2021-09-27T02:23:27Z