Product: TIBCO Spotfire®
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'
Login to database server and type the following command in the SQL console.