安装mysql8成功,用命令行登陆成功;
用Navicat(版本11.0.8),连接报错
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决:命令行输入
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456;
FLUSH PRIVILEGES;