I want to connect to database from PHP to MySQL.
MySQL version is 4.1
If I compile the php code below:
<?php
//list_db.php

$link_id = mysql_connect("localhost", "phpuser", "phppass");
$result = mysql_list_dbs($link_id);
$num_rows = mysql_num_rows($result);

while($db_data = mysql_fetch_row($result)) {
        echo $db_data[0]. "<BR>";
        $result2 = mysql_list_tables($db_data[0]);
        $num_rows2 = mysql_num_rows($result2);
        while($table_data = mysql_fetch_row($result2)) echo "--" . $table_data[0]. "<BR>";
        echo "==> $num_rows2 table(s) in " . $db_data[0] . "<P>";
}
?>

The error occurred:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\ch11\list_db.php on line 4

Warning: mysql_list_dbs(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\ch11\list_db.php on line 5

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\ch11\list_db.php on line 6

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\ch11\list_db.php on line 8

What’s the problem! Is there any configuration on mysql after I install it! And How can I connent PHP to Microsoft SQL Server and Microsoft Access!
Can somebody give me the solution. Thank You

What version of PHP have you installed? You might consider PHP5 if using MySQL 4.1, or note that PHP4 (while it works) is considered an old client to MySQL 4.1 and above - see the following regarding a change in MySQL 4.1 for passwords: http://dev.mysql.com/doc/refman/5.0/en/old-client.html. You can resolve the "old client" issue be following the instructions outlines.

I'm assuming you're environment is Windows (and I'm comparing to my 5.1.6 PHP install) - to connect to MS-SQL, uncomment the line "extension=php_mssql.dll" in php.ini and restart IIS.

Regarding MS Access - I think there may be fancier ways, but the short and easy answer is to connect over ODBC. Here's an article that might help: http://www.phpfreaks.com/tutorials/61/0.php