[SOLVED] calling mysql within php-4.4.4

[bruceg]

I need to use PHP-4.4.4 & MySQL. I can't seem to open MySQL from within the 4.4.4 environment althought it works just fine using 5.1.6.  When configuring PHP, I used the --with-mysql directive for both 4.4.4 and 5.1.6.  I have copied a very simple script below that fails and have the message from that shown below.  Any help would be appreciate.

[b]Script[/b]
#!/usr/bin/php --q
<?php

include('db_login.php');

$connection=mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("No connection: ".mysql_error());
}

?>

[b]Message[/b]
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/lib/asterisk/agi-bin/my_test.agi on line 6

No connection: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[wildteen88]

You need to reset your mysql password to use the old password function (OLD_PASSWORD). This [url=http://dev.mysql.com/doc/refman/5.0/en/old-client.html]page[/url[ should be able to help you.

[bruceg]

That was it - many thanks.