I was trying sqoop import and export between hdfs and mysql. I am using hortonworks cluster and wish to try two options viz.,
a) having mysql in the linux environment (have just one node i.e. server itself) and
b)having mysql in the host windows 10 machine.
Issue results of option a)
Followed itversity video (https://www.youtube.com/watch?v=VWwn8SIEglw) to install mysql in the linux environment but not able to get the mysql prompt upon invoking mysql with root as user and no password. Tried this exercise from cygwin and hortonworks shell (web).
Getting following error: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
Issue results of option b)
Could install mysql in windows 10 but could not get connected to windows 10 from linux environment (via cygwin or hortonworks web shell)
Thanks in advance