Sqoop 安装在Linux 环境,Mysql 安装在Windows系统,本地连接没有问题,但在Sqoop连接时报连接超时,如下:https://www.cndba.cn/dave/article/3301
https://www.cndba.cn/dave/article/3301https://www.cndba.cn/dave/article/3301
https://www.cndba.cn/dave/article/3301https://www.cndba.cn/dave/article/3301https://www.cndba.cn/dave/article/3301https://www.cndba.cn/dave/article/3301
[dave@www.cndba.cn lib]$ sqoop list-databases --connect jdbc:mysql://192.168.56.2:3306/ --username root -P
Warning: /home/hadoop/sqoop/../hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: /home/hadoop/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /home/hadoop/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
2019-03-02 23:15:14,946 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
Enter password:
2019-03-02 23:15:19,741 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
2019-03-02 23:17:27,246 ERROR manager.CatalogQueryManager: Failed to list databases
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
at