Just thought I'd put this out there as I couldn't find any info on the intertubes. There is plenty of info on how to do it on Drupal but not WordPress. Maybe I'm just stupid, but I though someone might need the info also.
Problem: We had to split our data and database between two servers and I couldn't figure out how to get the database to connect to the new server. Where did I punch in the IP numbers.
Solution: Open WP-config and change DB_HOST from localhost to the IP address of the server where the databases are. So now you know :)
// ** MySQL settings - You can get this info from your web host ** // /** MySQL hostname */ define('DB_HOST', 'The IP address of the server where the database is located. 192.xxx.xxx.xxx');