使用可视化工具链接mysql 8 报错:
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/Percona-Server-5.5.35-rel33.0-611.Linux.x86_64/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
发现新版MySQL都是默认用caching_sha2_password这个plugin来加密密码了,HeidiSQL无法接入。现改成原生密码的加密方式。
解决办法:
执行:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;