plugin caching_sha2_password could not be loaded
参考连接:
https://blog.csdn.net/qq_54202620/article/details/122729704
https://blog.csdn.net/qq_45214414/article/details/115284609
navicate可以连接,但是SQLyog不行,可直接在Navicat中执行以下命令
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';