MySQL connect to remote PHP/Apache server.How?


I’ve placed the php/Apache on one system and MySQL on another system. I want to access the mysql database. When i use the following mysql_connect statement its giving me an error as,

 Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in... Invalid server or user.

I’m using MySQL 5.0, Apache/1.3.29 (Unix) and PHP 4.3.4 version.

Mysql_connect() command used:

$username = "root";
        $password = "streamware";
        $db_name = "streamware1";
        $hostname = "";
        $connection  = mysql_connect("$hostname", "$username", "$password")
            or die("Invalid server or user.");

Please help.