Navicat連接配接MySQL報錯:1251-Client does not support authentication protocol requested by server;consider upgrading MySQL client
MySQL版本:8.0.22
解決方式:
按順序執行以下指令後再用Navicat連接配接:
- use mysql;
- alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘xxxxx’;
- flush privileges;
xxxxx是root使用者密碼
可以使用Navicat連接配接了,完結撒花✿✿ヽ(°▽°)ノ✿