Hadoop Cluster Environment Sqoop import data into mysql manyconnectionerr

In the hadoop cluster environment, use sqoop to import the data generated by hive into the mysql database. The exception Causedby: java. SQL. SQLException: null, messagefromserver: success; unblockwithmysqladmin

In the hadoop cluster environment, sqoop is used to import the data generated by hive into the mysql database. The exception Caused by: java. SQL. SQLException: null, message from server: Host 'datanode' is blocked because of unknown connection errors; unblock with 'mysqladmin

In the hadoop cluster environment, use sqoop to import the data generated by hive statistics to the mysql database. An exception occurs.

Caused by: java. SQL. SQLException: null, message from server: "Host 'datanode' is blocked because of encrypted connection errors; unblock with 'mysqladmin flush-hosts '"

This is a blocking caused by too many database connections (exceeding the maximum value of max_connection_errors) interrupted by the same ip address in a short period of time;

Solution: Enter mysql as an administrator and enter the following command: set global max_connect_errors = 1000;

Java. io. IOException: com. mysql. jdbc. MysqlDataTruncation: Data truncation: Out of range value for column 'traffic' at row 1

This problem occurs because the length of the traffic column field in the database is insufficient. You can modify the length of the field to solve the problem.