I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have
MySQL 5.5.19 installed on the laptop, and was able to connect to it via the
Windows Data Source Administrator app and the MySQL Connector/ODBC using a
TCP/IP connection to 'localhost'. I could connect to the MySQL database both via
the command-line client and via M$ Access and Excel.
I also have Virtualbox installed with a LAMP server running on a host-only
network. I can connect to the LAMP server via cmd.exe, PuTTY, Firefox, etc. I've
modified the mysql configuration on the LAMP server to accept connections from
other than just (its) localhost, and can connect to it across the (virtual)
network via the mysql command line client. I also have access to a remote web
host with a mysql server - I can connect to *that* server via ODBC as well.
What I can't seem to do is create an ODBC connection to the mysql database on
the LAMP server from the host PC. Specifically, when I type in the IP address
for the LAMP server on the host-only network '192.168.56.101' and click 'Test',
I get an error message that the connector couldn't establish a connection to
'192.168.56.1'. I've changed the IP address of the server on the host-only
network to '192.168.56.20' and still get the same error message:
'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for user
'ijdb'@'192.168.56.1' (using password: YES)'
...and no, the password isn't wrong. For some reason the ODBC connector isn't
even trying to connect to the IP address I supply it, but the address of the
local interface on that network.
I've asked a variety of places, including the MySQL ODBC forum and mailing list.
Those two are so dead it was a waste of time, and the other places I either get
no response or ones where its obvious people just read what they wanted into the
problem, not the details I actually supplied. I could *really* use some help on