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.

book

Article ID: KB0079104

calendar_today

Updated On:

Products Versions
Spotfire Server All supported versions.

Description

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.

Issue/Introduction

While creating a MySQL data source in the Information designer, it fails with the following error. "Database Reported: Null message from server. Host is blocked because of many connection errors. Unblock with mysqladmin flush hosts"

Resolution

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;
 

Additional Information

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
Powered by Wolken Software