Forum Discussion
On Premises Date Gateway Max connections error on MySQL
sdenter,
Please schedule a job to run the mysqladmin flush-hosts command from the MySQL administration shell.Or increase the max_connect_errors variable for your MySQL instance if the error still occurs.
There is a discussion in the following similar thread.
https://community.powerbi.com/t5/Desktop/DataSource-Error-MySQL-Host-is-blocked-because-of-many/td-p/60965
Regards,
Lydia
sdenter,
Please schedule a job to run the mysqladmin flush-hosts command from the MySQL administration shell.Or increase the max_connect_errors variable for your MySQL instance if the error still occurs.
There is a discussion in the following similar thread.
https://community.powerbi.com/t5/Desktop/DataSource-Error-MySQL-Host-is-blocked-because-of-many/td-p/60965
Regards,
Lydia