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

mysql mysql-workbench vmware-player
randxy picture randxy · Sep 9, 2014 · Viewed 11.8k times · Source

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

Answer

randxy picture randxy · Sep 9, 2014

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;

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More