将docker容器内mysql:8.0.17的配置文件夹映射到宿主主机

• 启动mysql:8.0.17容器

  [root@iZwz9dr90sxjudh8jngv50Z ~]# docker run -d -p 3306:3306 -v /usr/mysql:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0.17 
  f2d9278d4cbad888ecbd4631bb35e8d1d0edc8810d9f108a4c66471780ca2b6a
  

  /usr/mysql:宿主主机的文件夹。需要先创建好
  /etc/mysql/conf.d:mysql容器内的文件夹，mysql配置存放的地方
  如果没有mysql的镜像，会自己去拉取镜像

• 查看启动的容器

  [root@iZwz9dr90sxjudh8jngv50Z ~]# docker ps -a
  CONTAINER ID   IMAGE                  COMMAND                  CREATED              STATUS                    PORTS                                                                                  NAMES
  f2d9278d4cba   mysql:8.0.17           "docker-entrypoint.s…"   About a minute ago   Up About a minute         0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp                                   stupefied_easley
  ed6014f10f22   lt/new-mes:v20221119   "dotnet Langtian.Net…"   8 months ago         Exited (0) 5 months ago                                                                                          youthful_dhawan
  2dfc3a21983b   elasticsearch:7.3.2    "/usr/local/bin/dock…"   13 months ago        Up 9 months               0.0.0.0:9200->9200/tcp, :::9200->9200/tcp, 0.0.0.0:9300->9300/tcp, :::9300->9300/tcp   es
  
  
  

这样，在宿主主机目录/usr/mysql下创建my.cnf文件就相当于修改了容器的mysql配置：

[mysql]
	
# 设置mysql客户端默认字符集

default-character-set=utf8

[mysqld]

# 设置3306端口
port = 3306
#表名大小写不敏感
lower_case_table_names =1

Docker其他操作汇总

• 进入容器内部

  [root@iZwz9dr90sxjudh8jngv50Z ~]# docker exec -it f2d9278d4cba bash
  root@f2d9278d4cba:/# 
  

• 国内开源镜像汇总
  用于替换软件源，替换前先备份，解决某些软件国内无法下载的问题,例如vim

• 没有安装vim批量写入sources.list文件的方法，以阿里云镜像源为例

  cat >/etc/apt/sources.list <<EOF
  deb https://mirrors.aliyun.com/debian-archive/debian stretch main contrib non-free
  #deb https://mirrors.aliyun.com/debian-archive/debian stretch-proposed-updates main non-free contrib
  deb https://mirrors.aliyun.com/debian-archive/debian stretch-backports main non-free contrib
  deb https://mirrors.aliyun.com/debian-archive/debian-security stretch/updates main contrib non-free
  deb-src https://mirrors.aliyun.com/debian-archive/debian stretch main contrib non-free
  #deb-src https://mirrors.aliyun.com/debian-archive/debian stretch-proposed-updates main contrib non-free
  deb-src https://mirrors.aliyun.com/debian-archive/debian stretch-backports main contrib non-free
  deb-src https://mirrors.aliyun.com/debian-archive/debian-security stretch/updates main contrib non-free
  EOF