docker安装mysql容器后，是用navicat连接报client does not support authentication protocol requested by server consider upgrading mysql client

#进入容器
docker exec -it mysql bash
#进入mysql
mysql -u root -p
#重置密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';