使用sqoop命令列出MySQL的数据库时,报错:
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received
ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
解决办法:
修改配置文件 sudo vi /etc/mysql/my.cnf
port改为自己认为合适的
bind-address改为 0.0.0.0
再执行命令重启mysql服务:sudo service mysql restart
再执行:sqoop list-databases --connect jdbc:mysql://192.168.172.10:3310 --username root -P
不会报错,会显示结果。