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.
