I feel pretty dumb, not sure what I managed to do but I can't log into one database (I have two databases in VM boxes), the website it runs works fine, it works fine with local connections (ie, phpmyadmin) etc…
Database A I'm using MySQL Work Bench to connect to it, which works fine, and there are no problems, but Database B (which is almost the same) keeps giving me "mysql Error occured: Can't connect to MySQL server on … (ip and port)".
I have added the user I'm attempting to login as to the mysql Privileges, I've even taken my trouble shooting as far as adding the user to have global access from any connection and no password (don't worry, the machine is internal only and nobody even knows about it).
What could cause this sort of thing? I'm not overly advanced in mysql server administration so I'm not even sure where to start searching the web.
Best Answer
Check your my.cnf and look for the skip_networking parameter. Make sure it's commented out. While in there (assuming that's not the issue) you might also want to look for the bind-address setting and make sure it's not bound to the loopback address or something like that.