Archive for December 28th, 2004

MySQL 4.1 开始客户端协议验证方式变化

Tuesday, December 28th, 2004

今天给Debian更新了MySQL, PHP和PHPMyAdmin。开始空密码的时候用PHPMyAdmin登录还OK,不过当我用PHPMyAdmin改了密码之后再登陆就进不去了:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
可是我用的MySQL, PHP, PMA都是最新版的呀?
Google了一下,从MYSQL的网站得知:
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail [...]