[root@localhost ~]# mysql -h192.168.0.100 -uroot -p
Enter password:
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
登录报错
解决方案
进入容器登录mysql后添加如下指令：
alter user 'root'@'%' identified with mysql_native_password by '123456';
