好久沒(méi)有升級(jí)我的mysql樂(lè) 沒(méi)想到剛升級(jí)就出錯(cuò) 然后上網(wǎng)查了查 原來(lái)是這樣子的 mysql 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. ..... 請(qǐng)使用以下兩種方法之一
其一:
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;
