linux使用docker安装mysql，连接报错1251 client does no support authentic

通过navicat工具连接mysql报错1251 client does no support authentic，
1.docker exec -it mysql /bin/bash
2.mysql -uroot -proot
3.查看用户信息
select host,user,plugin,authentication_string from mysql.user;

4.修改用户密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
更新user为root，host为% 的密码为123456

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
更新user为root，host为localhost 的密码为123456

5.成功