天天看點

Navicat連接配接MySQL報錯:1251-Client does not support authentication protocol requested by server

Navicat連接配接MySQL報錯:1251-Client does not support authentication protocol requested by server;consider upgrading MySQL client

MySQL版本:8.0.22

Navicat連接配接MySQL報錯:1251-Client does not support authentication protocol requested by server

解決方式:

按順序執行以下指令後再用Navicat連接配接:

  1. use mysql;
  2. alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘xxxxx’;
  3. flush privileges;

xxxxx是root使用者密碼

Navicat連接配接MySQL報錯:1251-Client does not support authentication protocol requested by server

可以使用Navicat連接配接了,完結撒花✿✿ヽ(°▽°)ノ✿