windtear 追求完美

http://windtear.net/archives/2007/01/05/001185.html

Mysql 4.1 password 变化引起的 authentication protocol 支持问题解决办法

想要写的是 mysql 4.1 password 的变化

当 shell mysql 或 php mysql_pconnect 连接 mysql server 时 如遇到如下提示:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
则是因为 mysql 4.1 password 变化造成的

解决：
方法一：升级客户端的库
方法二：降级服务器的 password 用 old_password
configure the MySQL server with --old-passwords

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

Alternatively, use UPDATE and FLUSH PRIVILEGES: 

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

参考 refman-4.1-en.chm (对 mysql 5 同样适用)
5.7.9	Password Hashing as of MySQL 4.1
17.3.1	Common Problems with MySQL and PHP
A.2.3	Client does not support authentication protocol