com mysql jdbc exceptions jdbc4 CommunicationsException Communications link failure

Question

I am trying to import sql table to sqoop. This is the command I am using:

sqoop import --connect jdbc:mysql://hadoop/Testdb --table employee -m 4 --username root --password CHANGEME --driver com.mysql.jdbc.Driver

When I run this, I am getting the following error:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Answer 1

Sqoop is not able to communicate with sql. Check if mysql is running:

service mysql status

If it is not running, start the service:

service mysql start

and then run the sqoop command