List:General Discussion« Previous MessageNext Message »
From:Monte Milanuk Date:January 11 2012 7:12pm
Subject:Re: MySQL Connector/ODBC won't connect to internal network
View as plain text  
On 01/11/2012 09:45 AM, Johan De Meersman wrote:
> The connector is not trying to connect to the host address; it's connecting
*from* the host address - in your MySQL, the old grant for ijdb@localhost will
no longer work; you need to grant privileges to ijdb@stripped. 

I don't *want* to connect to the mysql server @ 192.168.58.1 - my local
interface on that network.  If I wanted to connect to the local server, I'd tell
it exactly that - localhost or 127.0.0.1.

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.

I can connect to that host via http/https/ssh, but not ODBC - and apparently not
via the regular myql cli client either.  I thought I could earlier, but I think
I mistook connecting via ssh *then* the mysql client, not straight from the
Windows host to the LAMP guest vm via  mysql client:

c:\users\monte> mysql -u monte -h 127.0.0.1 -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
...

c:\users\monte> mysql -u myusername -h my.webhost.com -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
...

c:\users\monte> mysql -u ijdb -h 192.168.56.20 -p
Enter password: ****
ERROR 1045 (28000):  Access denied for user 'ijdb'@'192.168.56.1' (using
password: YES)

Why is it stuck on trying to use that one specific ip address regardless of what
I specify?!?

I've tried it with the local mysql server (on the windows machine) stopped, so
the only mysql server on that network is the one on the LAMP vm - still no go.



Thread
MySQL Connector/ODBC won't connect to internal networkMonte Milanuk11 Jan
  • Re: MySQL Connector/ODBC won't connect to internal networkJohan De Meersman11 Jan
  • Re: MySQL Connector/ODBC won't connect to internal networkMonte Milanuk11 Jan
    • Re: MySQL Connector/ODBC won't connect to internal networkJohan De Meersman11 Jan
    • Re: MySQL Connector/ODBC won't connect to internal networkMonte Milanuk11 Jan