gooseflight

Seems to me that your wordpress user doesn’t have rights to access the wordpress database from localhost. If you use the following script, what happens?

<?php

$conn = mysql_connect(‘localhost’,’wordpress’,[password]);

if (!$conn) {
die (‘no connection’);
}

$selectdb = mysql_select_db(‘wordpress’, $conn);

if (!$selectdb) {
die (‘can\’t use wordpress: ‘.mysql_error());
} else {
echo ‘no error’;
}
?>

If you can connect to the server but can’t use the db then you need to allow your wordpress user to use the db from localhost.

Try creating a php file just to test the connection:

<?php
$conn = mysql_connect('sip1.sippal.com','user','password');
// should echo 'Resource id #[some number]'
echo $conn;
// now see what databases are available
$dbs = mysql_list_dbs($conn);
while ($row = mysql_fetch_object($dbs)) {
echo $row->Database;
}
// if wordpress is in the list try a query
$sql = "SELECT option_name FROM wordpress.wp_options";
$result = mysql_query($sql)
or die($sql);
echo mysql_num_rows($result);
?>