navicate远程连接mysql8.0失败 Error: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

分类: IT文章 • 2022-07-14 22:14:32

已经给了远程连接权限（update mysql.user set host = "%" where user = 'root'; flush privileges;）

连接错误提示：

解决方案：执行以下sql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'