Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Please help to resolve the below issue.
MySQL: Host '00.0.0.00' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Hi @vijay22kar ,
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.
How to unblock with mysqladmin flush hosts
Run the bash command in mysqladmin shell
flush-hosts
Fix Host ‘IP’ is blocked because of many connection errors on MySQL/MariaDB
Host is blocked because of many connection errors MySQL
1. Verify the connection
2. Increase the value of
max_connect_errors3. Flush host cache
DataSource.Error: MySQL: Host is blocked because of many connection errors (check the message 29 from @herbemischung)
1. Upgrade the version of on-premise gateway to the latest one
2. Upgrade the version of MySQL connector to the latest one
Best Regards
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 7 | |
| 4 | |
| 3 | |
| 3 |