« firefox accesskey 处理改动 | Main | KNOPPIX Linux Live CD V5.1.1 2007-01-04 发布及硬盘运行 »
January 5, 2007
Mysql 4.1 password 变化引起的 authentication protocol 支持问题解决办法
|
版权声明：可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明。 https://windtear.net/archives/2007/01/05/001185.html 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 |
Posted by windtear at January 5, 2007 11:54 PM
