mysql4.1 error:consider upgrading MySQL client [笔记]
mysql 4.1 错误:Client does not support authentication protocol requested by server; consider upgrading MySQL client解决: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;
如果还不行就:
use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;
例子:
SET PASSWORD FOR 用户名@localhost = OLD_PASSWORD('密码');
页:
[1]