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 协议》,转载必须注明作者和本文链接