I'm working on a web application that's using CakePHP and MySQL. Depending on the circumstances, I may be using one of two computers and I may be behind a proxy server that won't allow me to directly modify any code on my web server. Because of this, I've installed XAMPP on my machines to act as a local web server, and I keep my code in an SVN respository I can still access from behind the proxy.
With the web server, I have three places this code might be executed from (although it will ultimately only be on the web server), and since I'm in development, I'm constantly modifying the database. To make it easier on me, I want to set all three copies of this application to use the web server database so I don't have to keep exporting and importing each time I modify the database.
When I try to access the database, the first error I get is "Unknown MySQL server host 'mysql.mywebsite.com'". I'm assuming this is because I have to use an http proxy for all internet access, and without it, it can't even resolve an address. Can I configure CakePHP or PHP or my local Apache or whatever to use the proxy server in order to access my database?
