Docker之远程连接MySQL v5.6.51出现错误

• Docker之远程连接MySQL出现错误
• • 1.问题所在
  • 2.解决方案
  • 3.连接成功

注：本文是基于Ubuntu 20.04.4、Docker v 20.10.11、MySQL v5.6.51进行讲解

docker exec -it c_mysql /bin/bash
select host,user,plugin,authentication_string from mysql.user;
use mysql;
update user set host = '%' where user = 'root';
select host,user,plugin,authentication_string from mysql.user;

mysql -uroot -p******    -P3307  -hwww.foolartist.top