This is a weird one that I can't work out. It had three guys from Rackspace baffled too, but hopefully somebody out there has an idea what could be wrong.
Until recently I was using an older version of xampp. I can't remember the version but expect it was 1.5.x. Most of my localhost development sites ran off a shared database held on a hosting server. I updated to the latest versions of xampp and all of a sudden I have a problem connecting to one of the servers, our rackspace cloud server.
If I try and connect any of my local sites to my remote database on this server, I get the normal "Database Error: Unable to connect to the database:Could not connect to MySQL" message. If I change the database to a different server, it works fine.
This is the strange part: if I connect using a third party client, such as SQL Workbench / SQLYog, I can connect absolutely fine with all the privileges that I would expect. This proves that the server and mysql are configured to accept remote connections, so why should it be any different for a remote connection when I run through the new version of xampp on localhost? I can't help but think it's related to the hostname my local apache uses but I'm really not sure. Nothing shows up in the mysql logs on the server
Does anyone have any ideas?