zhwz 发表于 2018-9-29 06:55:48

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]
查看完整版本: mysql4.1 error:consider upgrading MySQL client [笔记]