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@192.168.56.1.
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
