解决mysql连接报错:1251-Client does not support authentication protocol requested by server;consider upgrading MYSQL client

使用navicat连接mysql8.0时报错：

1251-Client does not support authentication protocol requested by server;consider upgrading MYSQL client

解决方法是进入mysql的命令行

执行语句

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111';