How do you connect WordPress to a remote database?

[Cars-blog]

Does anyone know how to connect a WordPress installation to a remote MySQL database? My host uses a separate database server so the code

define('DB_HOST', 'localhost');

in the wp-config.php file doesn't work. I've tried putting the url in place of 'localhost' as well as the IP address as in

define('DB_HOST', 'http://db.domain.com:port');

and

define('DB_HOST', 'http://xxx.xxx.xxx.xxx:port');

where xxx.xxx.xxx.xxx is the IP address.

Both give me a Error connection to database message.

Usingthe IP address without 'http://' as in

define('DB_HOST', 'xxx.xxx.xxx.xxx:port');

gives me a CGI Error - The specified CGI application misbehaved by not returning a complete set of HTTP headers.

Any hep will be greatly appreciated?

[Costin Trifan]

I'd really like to know the answer to this question too, as I get more and more interested in this WP phenomenon.

So, if there's someone out there who knows the answer, please share

[cheap seo]

i also wanted to know pls

[nasty.web]

These settings are correct:

define('DB_HOST', 'xxx.xxx.xxx.xxx:port'); // or
define('DB_HOST', 'db.domain.com:port');

Also:
- make sure, that DB server is accessible from the outer world
- make sure, that your DB user is allowed to connect from your web server

[Cars-blog]

Thanks for the input guys. I've smacked the installation down to WordPRess 2.3.1 and it works perfectly now with

define('DB_HOST', 'xxx.xxx.xxx.xxx:port');

Looks like the problem was with WordPress 2.3.2