mysql 2059

mysql 2059

Navicat premium 12.0.11
mysql for windoms 8.0.19.0

mysql新版使用cahing_sha2_password验证方式
但使用Navicat premium还没支持

解决步骤：
cmd:

mysql -uroot -p
password:root
use mysql;

alter user 'root'@'localhost' identified with mysql_native_password by 'root';
alter user 'root'@'%' identified with mysql_native_password by 'root';
flush privileges;

plugin已改为mysql_native_password：

select user,host,plugin from user where user='root';