连接数据库出现 ------------------------------------------------------------------------------------------- client does not support authentication protocol requested by server; consider upgrading mysql client ------------------------------------------------------------------------------------------- 由于mysql 4.1版本开始密码的hash算法改变,所以连接数据库 时可能会出现client does not support authentication protocol问题。
可以通过一下两种方法解决 其一: mysql> set password for -> 'some_user'@'some_host' = old_password('newpwd');
其二: mysql> update mysql.user set password = old_password('newpwd') -> where host = 'some_host' and user = 'some_user'; mysql> flush privileges;