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';