database connection settings

[SAORSA]

Hi, I am trying to set up my database connection so I keep my admin site running on localhost, but it connects to the mysql db on my hosting company's server. The problem I have is that they don't allow connections to their dbs from sites that aren't hosted on their servers, so I get connection refused.

 

After speaking to their tech support, I opened a tunnel using putty to their db server on port 3007. The tunnel works fine when tested using telnet commands from a dos prompt, but I don't know what to put in the configure.php file to define DB_SERVER. I tried the following, but it didn't work:

 

define('DB_SERVER', 'localhost');

also

define('DB_SERVER', 'localhost 3007');

also

define('DB_SERVER', 'innodb.hostsite.com');

 

 

Any thoughts anyone??

[SAORSA]

problem solved....should have been

 

// define our database connection

define('DB_SERVER', 'localhost:3007');