From: Johan De Meersman Date: January 11 2012 7:22pm Subject: Re: MySQL Connector/ODBC won't connect to internal network List-Archive: http://lists.mysql.com/mysql/226595 Message-Id: <6aea00b3-ef56-49f1-9fc3-9ef1dbd0e451@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Monte Milanuk" > > Again, I *don't* want to connect to 192.168.56.1 - I want to connect > to 192.168.56.20 - so why the heck is mysql refusing to do that. Yes. Now take a deep breath and read what I said again. You can perfectly connect to .20 - as proven by the "access denied" message you get instead of a "cannot connect to host". You are, however, going to 192.168.56.20, which means that your network packets enter the host-only network from your hosts's (virtual) interface 192.168.56.1. That means that the guest you have MySQL running on will see a connection coming in from 192.168.56.1. The bit you are missing, is that the host part of a full MySQL user specification is not the server's IP, but the client's - and that is your host: 192.168.56.1. Thus, simply open a mysql client on the guest and issue GRANT ALL PRIVILEGES ON *.* TO 'ijdb'@'192.168.56.1' IDENTIFIED BY 'yourpassword'. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel