Authentication plugin ‘caching_sha2_password‘ cann 
                                                    
                        
                    
                    
  
                    
                    navicate11 不支持mysql 8.0最新的加密方式,链接报错,所以改为老的
进入容器
docker ps
docker -it mysql /bin/bash登录mysql
mysql -uroot -p
输入密码修改加密方式
`mysql -uroot -p
Enter password:
mysql> ALTER USER ‘root‘@’%’ IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER ‘root‘@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
`
本作品采用《CC 协议》,转载必须注明作者和本文链接
          
 lixueyuan 的个人博客
        
          
          
                关于 LearnKu