PHP web page fails to connect to MySql server but won't tell me why not

[woozy]

I'm actually embarrassed to post this question because it is so general and vague but... well, I'm stumped

I recently had to reinstall PHP (4.4.1. for windows) and Mysql Server (4.1) and, well, I can't get a php connect and that is all I know.

I've written:

$db_user = 'webreader';
$db_password = 'w4reed';
$database = 'sirentiger';
$db_host = 'localhost';

$q = DB::connect("mysql://$user:$password@$host/$database");
if (DB::isError($q)){
die($q->getMessage();
}

And all I get is a simple message "DB Error: connect failed " And that's it! I've tried rewriting the connect command to use the root account and a variaty of other options.

I wouldn't feel so bad trying to debug but I'm not getting any response at all. Nothing shows up in the Web Server errer logs, nor in the MySql server error logs or anything. What can I do to trouble shoot? I don't have any idea why it's failing to connect and the message "DB Error: connect failed " is not very informative.

Any help appriciated!

Thanks.

[tomhath]

$db_user = 'webreader';
$db_password = 'w4reed';
$database = 'sirentiger';
$db_host = 'localhost';

$q = DB::connect("mysql://$user:$password@$host/$database");

You aren't using the variables you are setting: :eek:

$db_user or $user ???
$db_password or $password ???
$db_host or $host ???

[woozy]

tomhath wrote:

$db_user = 'webreader';
$db_password = 'w4reed';
$database = 'sirentiger';
$db_host = 'localhost';

$q = DB::connect("mysql://$user:$password@$host/$database");

You aren't using the variables you are setting: :eek:

$db_user or $user ???
$db_password or $password ???
$db_host or $host ???

Oh, for crying out...

No. I actually edited my script. My full script is below and I am sending the right variables:

on the page:
require_once("php_config/sql.php");
$db = get_db();

and on "sql.php":

require_once("php_config/global.php");
global $host;

switch ($host){
case "www.sirentiger.com":
$db_user = 'woozy_webreader';
$db_password = '#####;
$database = 'woozy_sirentiger';
$db_host = 'localhost';
break;
case "localhost":
$db_user = 'webreader';
$db_password = '#####';
$database = 'sirentiger';
$db_host = 'localhost';
break;
}

function get_db($host, $database, $user, $password){
require_once('DB.php');
$q = DB::connect("mysql://$user:$password@$host/$database");
if (DB::isError($q)){
die($q->getMessage()." $user $password $host $database");}
return $q;
// return DB::connect("mysql://$user:$password@$host/$database");
}
function return_db(){
global $db_user, $db_password, $database, $db_host;
return get_db($db_host, $database, $db_user,$db_password);
}

[woozy]

For what its worth I managed to solve the issue. MySQL 4.4.1 like MySQL 5 has a new more secure 32 bit (vs 16 bit) encryption. I had to use the "OLD_PASSWORD" functions to encrypt the password in the old manner.