This is the specific Q: I have apache running on ubuntu in parallels and mysql running on this VM and on the host OS X. Since I try to emulate my production environments locally I connect to the remote mysql server on OS X. I do that successfully for some clients and now I have a new one.
I have umhef.ca, osx and dom.biz in my ubuntu hosts file. When I ping OS X from ubuntu, it reports success and the right IP. My drupal settings file is set the host to 'osx' and the user 'rootd'. The user is set up on the OS x mysql server with rights to this db. How do I know this? I can see other users that successfully set up in mysql and they appear to be the same as this user.
That's background to help me troubleshoot why I'm getting this error: PDOException: SQLSTATE[HY000]  Access denied for user 'rootd'@'umhef.ca' (using password: YES)
WTF is this host coming from? It's legitimate host as it and the others point to the Os x VM. So to troubleshoot this I attempt this from ubuntu:
mysql --host=osx --user=rootd --password=mypassword Access denied for user 'rootd'@'umhef.ca' (using password: YES)
I've tried commenting out my ubuntu hosts file, but why is ubuntu ignoring my host parameter? What else should I use to troubleshoot this? thx, sam