好久没有升级我的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. ..... 请使用以下两种方法之一
其一:
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;