MySQL WorkBench failed to connect to Mysql at XXX.XXX.XXX with user root [Host to Vmware]

Question

I installed mysql 5.6.20 in vmware win XP, While trying to connect the database from the host [windows 7] using MYSql Workbench. In vmware NAT is enabled. also with DHCP

Failed to Connect to my sql at XXX.XXX.XXX.XXX with user root

Advance Thanks

Solution

Finally got the answer, Just adding a new user with all privileges in Mysql and the connection got established in Mysql workbench.

  mysql> CREATE USER 'randxy'@'localhost' IDENTIFIED BY 'root_password';
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'randxy'@'localhost'
   ->     WITH GRANT OPTION;
  mysql> CREATE USER 'randxy'@'%' IDENTIFIED BY 'password';
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'randxy'@'%'
   ->     WITH GRANT OPTION;