[inSignifico]

hi, I have :
Php 4.3.8
Mysql 4.1
IIS 4

I used to work fine, but recently, when I started Phpmyadmin, it gave me this error :

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

This is a relatively new problem for me, so please help me how to fix it.

[yasmin]

hi,
i have come across this problem and manage to solve it.
try this;
1. check first host, user and their password from mysql dbase.

>SELECT Host, User, Password FROM mysql.user WHERE LENGTH(Password) > 16;

2. then you have to reset the password to mysql4.1 style for user that needs to use the client program e.g root

>SET PASSWORD FOR
->'root'@'localhost' = OLD_PASSWORD('newpasswd');

hope this helps

[suminda]

If you are using PHPMyAdmin, just go the the "Privileges" tab.
Edit the user containing username and host you want to use with. In the "Change Password" box below, you can choose whether using password or no. The solution is in there: Choose "MySQL 4.0 Compatible" and "Go".