navicate远程连接mysql8.0失败

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

连接错误提示：

Error: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

解决方案：执行以下sql

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