[Xitami] problem with php and mySql

[Antonio - poste.it]

Hi all!

I try to connect to a mySql database with a php page, but receive a warning
message that states:
"Client does not support authentication protocol..."
What's wrong?
Thanks!

In a different machine a similar connection (IIS; mySql 4.1.6gamma-nt; php
5.1.2) is OK, but I need to work with xitami (or a different free server,
running under Win-XP Home).

Detailed information:

My environment:
Windows XP Home Version 5.1 (Build 2600: Service Pack 2)
PHP Version 4.3.10
Xitami 2.5c2
MySQL version: 4.1.10-nt

Process mysqld-nt.exe is running.

>From phpinfo:
MySql support enabled
Client API version  3.23.49

Phpinfo runs OK, like other simple php functions.
Mysql queries are OK for the specified user/pwd.

In my php.ini, in Windows Extensions section, I read:
;Note that MySQL and ODBC support is now built in, so no dll is needed for
it.
(in fact in php.ini there is no extension=php_mysql.dll, commented or not)

The warning arise only when I specify a valid user and any password which
length is greater then zero.

Source testmysql.php file:
---------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
  <title>TITOLO</title>
</head>
<body>

<?php
$link_id = mysql_connect('localhost', 'theuser', 'thepass');
?>

</body>
</html>
---------------

Refreshing the page, gives the following warning message:

Warning: mysql_connect(): Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
C:\xitami-25\app\webpages\memo\_testmysql.php on line 10


Thanks!
Antonio Angelo
antonio.angelo@my-site.it