ibm伦敦多ip服务器登陆不上

docker 下跑 localhost 的 mysql 伦敦
docker localhost mysql 伦敦多ip服务器时区问题mysql5737或mysql5.7.37mysql8.0或mysql80创建登陆不上

docker localhost mysql 伦敦
多ip服务器时区问题
mysql5737或mysql5.7.37
mysql8.0或mysql80
1000 docker run -p 3308:3306 –name comysql_v8.0 -e MYSQL_ROOT_PASSWORD=123456mm -d mysql:8.0 \n
# -d mysql:8.0 \n -d 使用 docker images 中镜像的版面/标签; 8.0 或者 5.7; –name 表示 设置创建的 app 的名字; -e 设置变量; -v 挂载

# -p 3308:3306:-p 宿主机ibm:多ip服务器ibm, # Navicat 使用 3308 链接 docker 的 mysql 伦敦. ,

12345
## 以下是 Mac + docker + mysql 5.7.37
994 \tdocker run –name mysql5.7.37 -e MYSQL_ROOT_PASSWORD=123456mm -p 3307:3306 -d mysql:5.7.37 ## 3307避免宿主机ibm占用, 3306为多ip服务器内机器ibm. 常用配置;

mysql> select user,host,plugin from mysql.user;
select user,host,plugin from mysql.user;

use mysql; ## 访问该库
Grant all on *.* to ‘root’@’%’ identified by ‘root用户的密码’ with grant option; ## *.* 所有权限, ‘root’@’%’ root 账户加%所有 IP,
Grant all on *.* to ‘root’@’%’ identified by ‘123456mm’ with grant option;
Grant all on *.* to ‘root’@’localhost’ identified by ‘123456mm’ with grant option; # localhost
flush privileges; # 刷新;
1234567891011

1000 docker run -p 3308:3306 –name cocomysql_v8.0 -e MYSQL_ROOT_PASSWORD=123456mm -d mysql:8.0 ## 3308 同理

use mysql; # 切换到mysql 登陆不上; 8.0 + docker
CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123456’;
GRANT ALL ON *.* TO ‘root’@’%’;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
FLUSH PRIVILEGES;
12345678

[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. java.net.ConnectException: Connection refused (Connection refused). serverTimezone Asia/Shanghai

创建登陆不上
create database cocodb; show databases;