Question

I am getting connection failure exception during connecting to Mysql through Sqoop, what is the root cause and fix for this error scenario?

Answer 1

This will happen when there is lack of permissions to access our Mysql database over the network. We can try the below command to confirm the connect to Mysql database from aSqoop client machine.

$ mysql –host=MySqlnode> –database=test –user= –password=

We can grant the permissions with below commands.

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘%’@’localhost’;

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘ ’@’localhost’;