MySql8.0常见的问题及解决方法

Navicat连接Mysql报错：Client does not support authentication protocol requested by server

Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server；解决如下：

；命令如下：
1、use mysql;
2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
3、flush privileges;