Creating a MySQL data source in Information designer fails with the "Host is blocked because of many connection errors. Unblock with mysqladmin flush hosts." error.

Creating a MySQL data source in Information designer fails with the "Host is blocked because of many connection errors. Unblock with mysqladmin flush hosts." error.

The error faced while creating a MySQL data source "Database Reported: Null message from the server. Host is blocked because of many connection errors. Unblock with mysqladmin flush hosts" is a database side error and occurs due to multiple connections created while connecting the database. To resolve the above error, you need to execute "Flush hosts " command. You can execute the command as per below syntax.

If you have shell access to the server, you can log in on the database machine, and execute the following:
mysql -u root -p -e 'flush hosts'

OR

Login to database server and type the following command in the SQL console.
FLUSH HOSTS;
  https://stackoverflow.com/questions/21519997/how-to-do-mysqladmin-flush-hosts-on-server

https://stackoverflow.com/questions/8014358/how-to-run-command-mysqladmin-flush-hosts-on-amazon-rds-database-server-instan

https://stackoverflow.com/questions/41704223/mamp-blocked-because-of-many-connection-errors-unblock-with-mysqladmin-flush