root 用户远程链接报错信息:
Failed to Connect to MySQL at 10.211.55.6:3306 with user root
Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
修改方式:
在本地进入 mysql 之后,执行以下sql:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';