I just started learning sqoop in pseudo mode , Now I am trying to install sqoop in multinode cluster for the testing purpose , I stuck in the middel please help me.
I have 4 nodes - with YARN ,hdfs configuraton and all the dameons.
Now i install mysql in one node , i am sure when it is not a uber job it will spread across the nodes having said that how will access the mysql database that is installed in master node.
Look into the few forums for making mysql accessible from the remote host. inspite of doing all the below
still it says email@example.com does not have access to the host.
1 . addedd the bind address in /mysql/my.cnf file
2 . gave all the privieges to firstname.lastname@example.org in mysql as root.
3. flushed privileges.
4.all the other host have jdbc driver connections in the sqoop client.
is there any blog that gives a step by step installation sqoop in multinode cluster.
host 1 has sqoop installed and mysql
host 2 - i am executing the below
sqoop list-tables \
--connect jdbc:mysql://MasterNode/movieData \
i added the below in the my.cnf file
bind-address = 0.0.0.0
also gave the full privilege to the user.
i am not sure which one solved the issue. but now i am able to login from remotely.
i think mentioning 0.0.0.0 is unsafe - because it will let all the ip-adr.
please let me know your thoughts folks.