关于mysql 4.0客户端不能连接的问题

From mysql 4.0 client connect mysql 4.1 server, encounter the following error:

 

ERROR 1251: Client does not support authentication protocol requested by server;consider upgrading MySQL client

    如果升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client是4.1或者更高版本.(WINDOWS下有问题你就直接跳到下面看解决方法了,因为MYSQL 在WINDOWS是client和server一起装上了的)       
mysql>   UPDATE     mysql.user     SET     Password=OLD_PASSWORD( 'newpwd ')       
WHERE       Host   =   'some_host '   AND   User   =   'some_user ';      
   

mysql>   FLUSH  PRIVILEGES;