DataSource.Error: MySQL: Host is blocked because of many connection errors

Turn on Tracing by going to File | Options and settings | Options | Diagnostics and click Tracing checkbox. Generate the error and then click the smiley face icon to send a frown and include screen shot, trace logs, etc.

---

Hike_N wrote:

Hi smoupre

It happens that I am trying to refresh the data:

 

 

The error attached in a previous post
When I open the Query Editor

 

---

Hike_N

The MySQL Online book says

• If the following error occurs, it means that mysqld has received many connection requests from the given host that were interrupted in the middle:
  

  Host 'host_name' is blocked because of many connection errors.
  Unblock with 'mysqladmin flush-hosts'

  The value of the max_connect_errors system variable determines how many successive interrupted connection requests are permitted. (See Section 6.1.4, “Server System Variables”.) After max_connect_errors failed requests without a successful connection, mysqld assumes that something is wrong (for example, that someone is trying to break in), and blocks the host from further connections until you issue a FLUSH HOSTS statement or execute a mysqladmin flush-hosts command.

So in my opinion, the first thing before "unblock" is to analysis the failed connections, I don't know about MySQL but I think there should be any log feature indicating the failed connection details.

Do you connect to Amazon RDS via "getdata"->"database"->"MySQL" and and install a gateway? When saying refresh, if you schedule the refresh through a gateway, as per the bold part of the quoted, try to monitor the connections from the server where the gateway is hosted in your MySQL database. By the way, have you confirmed that the database credential is set up correctly? I doubt the invalid crendential keeps failing the connection to your RDS from gateway.