使用navicat连接mysql报client does not support authentication protocol requested by server解决办法

今天安装了mysql8.0.13,安装成功后使用navicat连接时报client does not support authentication protocol requested by server;consider upgrading MySQL client

解决方案:

步骤一:在黑窗口使用命令登录mysql

使用navicat连接mysql报client does not support authentication protocol requested by server解决办法

步骤二:执行 use mysql;

使用navicat连接mysql报client does not support authentication protocol requested by server解决办法

步骤三:执行alter user 'root'@'localhost' identified with mysql_native_password by '密码';

使用navicat连接mysql报client does not support authentication protocol requested by server解决办法

到此处就可以使用navicat连接到mysql了,如果不行可以执行步骤四刷新一下

步骤四:执行FLUSH PRIVILEGES;