docker 下运行容器加 mysql5.7.37 或docker 下运行容器加 mysql8.0本地mysql 数据库服务搭建

docker localhost mysql 服务

容器时区问题

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 宿主机端口:容器端口， # Navicat 使用 3308 链接 docker 的 mysql 服务. ,https://blog.csdn.net/weixin_39305029/article/details/105019334?utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2~aggregatepage~first_rank_ecpm_v1~rank_v31_ecpm-1-105019334.pc_agg_new_rank&utm_term=0+0+%3A%3A%3A*+%3A%3A%3A3306+LISTEN+tcp6&spm=1000.2123.3001.4430

## 以下是 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避免宿主机端口占用, 3306为容器内机器端口. 常用配置; 

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; # 刷新;

 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;

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

创建数据库

create database cocodb;
show databases;