Forum Discussion
Solved
On Premises Date Gateway Max connections error on MySQL
Hello everybody, I'm having problems with our On Premises Date Gateway. I have three data sources, two MySQL databases and one MSSQL database, the MySQL databases are on different servers. One ...
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
I could solve the problem, I looked at the wrong variable.
I looked at max connections, but it's max_connect_errors.