I am using VMware (v 1.3) and I have Windows 7 as a host (with public IP) and Ubuntu (10.10) as a guest OS (with private IP that is assigned by VMware 192.xxx.xxx.xxx).
In Ubuntu, I have a mysql server that I can access it from the localhost (ubuntu) with no problems. Now, I have a separate (remote) machine that I want to connect to the mysql server on the Ubuntu VMware.
the command I am using from the remote machine:
mysql -u UserName –h WindowsIP –p
But I can't connect:
ERROR 2003 (HY000): Can't connect to MySQL server on WindowsIP
The windows firewall is off.
I can ping, access the remote machine from the Ubuntu box itself, but I can't do it the way around. Basically I can ssh or mysql:
Ubuntu (Vmware)---->remote machine (Ubuntu)
but I can't:
remote machine -->windows7---->Ubuntu (VMware)--->Mysql
and this is what I am trying to achieve here.
I appreciate any help,
- Windows IP address 18.104.22.168
- Vmware network: NAT
- VMware Network Adapter
- VMnet8: 192.168.230.134
When I try to connect from remote client to windows host, following is the error:
mysql -h 22.214.171.124 -p Enter password: **** ERROR 2003 (HY000): Can't connect to MySQL server on '126.96.36.199' (111) server
In mysql server (ubuntu guest), I change the
bind-address to host 188.8.131.52 (host ip) in
/etc/mysql/my.cnf. However, I noticed that mysql is refusing to restart/start when I use any value in bind-address.
also, I created the remote user in the mysql:
create user 'root'@'184.108.40.206' IDENTIFIED by 'turki'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'220.127.116.11' IDENTIFIED BY 'turki' WITH GRANT OPTION;
and I still can't connect from remote client!