Hi Randy,

Please understand, you must had configure your mysql to localhost.
But you are trying to access it with IP of Host(window) in VM(ubuntu) which is not possible unless you configure your mysql to use window IP. This is one of the reasons why it did work.

Other reason may be:

1. Firewall is blocking the connection.
2. Proper privilege is not provided.
3. Connectivity issue between Host and VM.

Just follow the below links for more make it work(surely check those links):

http://askubuntu.com/questions/19581/how-to-access-mysql-on-windows-from-ubuntu

http://askubuntu.com/questions/435554/remotely-access-mysql-db-on-vm-from-windows-as-host

Hope this helps.

Thanks.

It doesn't help.  I cannot perform step 19 in the Module9_Sqoop_MysqlToHDFS.sql
Module9_Sqoop_MysqlToHDFS.pdf, page 19, step 19: IPconfig command to find out IP of MySQL shows a reference to a VMWare IP-Address. How do I do this step?  Executing the ipconfig command per document returns these ip addresses.

Ethernet adapter Ethernet 3:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::8806:5b51:6358:8b05%25
   IPv4 Address. . . . . . . . . . . : 192.168.73.1
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :

Ethernet adapter Ethernet 4:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::980b:e6fc:6b03:da65%24
   IPv4 Address. . . . . . . . . . . : 192.168.50.1
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :

Wireless LAN adapter Wi-Fi:

   Connection-specific DNS Suffix  . : home
   Link-local IPv6 Address . . . . . : fe80::f061:8da3:aa6e:c784%18
   IPv4 Address. . . . . . . . . . . : 192.168.1.5
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.1.1

Virtual Machine ifconfig returns

ifconfig
eth1      Link encap:Ethernet  HWaddr 00:0C:29:F0:46:6C  
          inet addr:192.168.50.146  Bcast:192.168.50.255  Mask:255.255.255.0
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:10881 errors:0 dropped:0 overruns:0 frame:0
 

Windows c:\>hostname

DESKTOP-H61VAGD

nslookup DESKTOP-H61VAGD returns 

        Server:  Wireless_Broadband_Router.home
        Address:  192.168.1.1

        Name:    DESKTOP-H61VAGD
        Address:  192.168.1.5

MySql: grant all privileges on *.* to 'root'@'192.168.50.146' IDENTIFIED BY 'root' WITH GRANT OPTION;

Query OK, 0 rows affected, 1 warning (0.00 sec)

What am I doing wrong here.

Hi Randy,

Try this link:

http://askubuntu.com/questions/19581/how-to-access-mysql-on-windows-from-ubuntu

Hope this helps.

Thanks

This is the same link you sent before.   Why do I need to install more software to resolve an IP address.  There should be a windows command that gives me what I need.  The document say ipconfig. 

Hi Randy,

Start with binding IP address and disable firewall.
If doesn't work, then only you have install third party application to make sure it work.

Thanks