hi all...im brazilian, so my english may not be veryy good hehe but i'll try

i was getting an error when trying to install xoops, "could not connect to the database", so i tried some php codes to test the MySQL server

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

when using localhost, even when using the root account or another account, i've got the error

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in E:\Program Files\YellowTip\Htdocs\teste.php on line 2
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

when using my ip, with the account different from root, i've got a different error:

Warning: mysql_connect(): Access denied for user 'drago'@'home' (using password: YES) in E:\Program Files\YellowTip\Htdocs\teste.php on line 2
Could not connect: Access denied for user 'drago'@'home' (using password: YES)

yes, im sure the password is correct

and when i try to use root with my ip, i've got the firt error

any ideas?

=(

i couldnt found any "edit" button, so im posting again to say that i fix the problem

as said inhttp://dev.mysql.com/doc/mysql/en/Old_client.html, there is a problem with the new MySQL server version 4.1 and the "old clients"

i fix it with

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

and then it worked

thx :)