Ok, just to be sure i used the following script to check my database connection....and it worked perfectly.
**** replaced with username and password.
<?php
// hostname or IP of server (for local testing, localhost should work)
// replace loscalhost if other host for db !! on dedicated server environment
// it usually is localhost for most people - also for your local machine
// adapt the following to your needs below in below php script
// your-db-user = real username for a particular mysql db
// yourpassword = real password for a particular mysql db
// your_db_name = real db-name for a particular mysql db
//
// expand same to as many mysql db as needed - changing the number after all names as below !!
//
// script tested with PHP5 on SuSE/Novel Linux 10.1 - for free use - OS - have fun
//
// security alert - it is best you chmod 000 this file after use - just in case !
// and before use chmod again back to 644
//
// RENAME this file with file extension .php before use !!!
//
$dbServer1='localhost';
// username and password to log onto db server
$dbUser1='*****';
$dbPass1='*****';
// name of database
$dbName1='wordpressdb';
$link = mysql_connect("$dbServer1", "$dbUser1", "$dbPass1") or die("Could not connect post");
print "Connected successfully to your_db_name1<br>";
print $dbName1;
print $dbUser1;
print $dbPass1;
mysql_select_db("$dbName1") or die("Could not select database your_db_name1");
print "Database your_db_name1 selected successfully<br><br><br>";
// close connection
mysql_close($link);
// hostname or ip of server (for local testing, localhost should work)
$dbServer2='localhost';
// username and password to log onto db server
$dbUser2='your-db-user2';
$dbPass2='yourpassword2';
// name of database
$dbName2='your_db_name2';
$link = mysql_connect("$dbServer2", "$dbUser2", "$dbPass2") or die("Could not connect your_db_name2");
print "Connected successfully to your_db_name2<br>";
mysql_select_db("$dbName2") or die("Could not select database your_db_name2");
print "Database your_db_name2 selected successfully<br><br><br>";
// close connection
mysql_close($link);
// hostname or ip of server (for local testing, localhost should work)
$dbServer3='localhost';
// username and password to log onto db server
$dbUser3='your-db-user3';
$dbPass3='yourpassword3';
// name of database
$dbName3='your_db_name3';
$link = mysql_connect("$dbServer3", "$dbUser3", "$dbPass3") or die("Could not connect your_db_name3");
print "Connected successfully to gallery<br>";
mysql_select_db("$dbName3") or die("Could not select database your_db_name3");
print "Database your_db_name3 selected successfully<br><br><br>";
// close connection
mysql_close($link);
?>
Am starting to hate wp. grrrrrr.
