Host ‘x.x.x.x.’ is not allowed to connect to this MySQL server.

在局域网中使用Docker远程连接数据库报错：
Host ‘x.x.x.x.’ is not allowed to connect to this MySQL server.
原因：未给root用户赋予远程登录权限

解决办法：
1、查看当前运行的docker容器

[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                COMMAND                  CREATED             STATUS                    PORTS                      
                         NAMES
4b789c107052        mysql/mysql-server   "/entrypoint.sh mysq…"   29 minutes ago      Up 29 minutes (healthy)   0.0.0.0:32769->3306/tcp, 0.
0.0.0:32768->33060/tcp   mysql03
010a32224776        mysql/mysql-server   "/entrypoint.sh mysq…"   40 minutes ago      Up 40 minutes (healthy)   0.0.0.0:3306->3306/tcp, 330
60/tcp                   mysql02

2、在mysql02容器中以root用户登录MySQL

[root@localhost ~]# docker exec -it mysql02 mysql -uro