连接docker mysql 出现caching_sha2_password问题

1.docker启动mysql报下面的错误：

2.百度后解释为：MySQL8.0采用了新的更安全的验证方式

3.解决方法：

进入容器：docker exec -it mysql-flink bash

登录mysql：mysql -u root -p

执行下面命令：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
 
ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY '123456';

然后再用navicat