如何使用Docker启动和初始化Mysql 8？

huangapple
go评论99阅读模式
英文:

How to start and initialize Mysql 8 using Docker?

问题

我一直在收到这个错误：构建Docker镜像时，从我的Dockerfile运行docker-compose up，然后运行docker-compose up时，出现错误mysqld: File '/var/lib/mysql/auto.cnf' not found (OS errno 13 - Permission denied)。我使用以下命令构建Docker镜像：docker buildx build --platform linux/amd64 --load -t mysqltest -f path/to/Dockerfile .。我使用buildx构建Docker镜像，因为我在运行具有M1芯片的Mac。我希望这个镜像能够在Intel机器上运行。以下是Docker文件：
Dockerfile：

  1. FROM mysql/mysql-server:8.0.32
  3. # needed for initialization
  4. ENV MYSQL_ROOT_PASSWORD=test_password
  5. ENV MYSQL_DATABASE=new_database
  6. ENV MYSQL_USER=user
  7. ENV MYSQL_PASSWORD=test_password
  9. RUN microdnf update && microdnf -y install vim
  11. EXPOSE 3306
  12. CMD ["mysqld"]

docker-compose.yml

  1. version: "3.7"
  3. networks:
  4.   backend:
  5.     driver: ${NETWORKS_DRIVER}
  7. services:
  8.   
  9. ...
  11.   db:
  12.     image: mysqltest
  13.     container_name: db
  14.     build:
  15.       context: .
  16.       dockerfile: ./path/to/Dockerfile
  17.     restart: always
  18.     env_file:
  19.       - .env
  20.     ports:
  21.       - "3306:3306"
  22.     expose:
  23.       - "3306"
  24.     volumes:
  25.       - db-volume:/var/lib/mysql
  26.       - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  27.       - ./docker/db/configs:/etc/mysql
  28.     networks:
  29.       - backend
  30. ...
  32. volumes:
  33.   db-volume:
英文:

I keep getting this error: mysqld: File '/var/lib/mysql/auto.cnf' not found (OS errno 13 - Permission denied) when building the docker image from my Dockerfile and then running docker-compose up using my docker-compose.yml file. I'm using this command to build the docker image docker buildx build --platform linux/amd64 --load -t mysqltest -f path/to/Dockerfile . I'm using buildx to build the docker image because i'm running a mac with m1 chip. I want this image to be able to run on an intel machine. Below are the docker files:
Dockerfile:

  1. FROM mysql/mysql-server:8.0.32
  3. # needed for intialization
  4. ENV MYSQL_ROOT_PASSWORD=test_password
  5. ENV MYSQL_DATABASE=new_database
  6. ENV MYSQL_USER=user
  7. ENV MYSQL_PASSWORD=test_password
  9. RUN microdnf update && microdnf -y install vim
  11. EXPOSE 3306
  12. CMD ["mysqld"]

docker-compose.yml

  1. version: "3.7"
  3. networks:
  4.   backend:
  5.     driver: ${NETWORKS_DRIVER}
  7. services:
  8.   
  9. ...
  11.   db:
  12.     image: mysqltest
  13.     container_name: db
  14.     build:
  15.       context: .
  16.       dockerfile: ./path/to/Dockerfile
  17.     restart: always
  18.     env_file:
  19.       - .env
  20.     ports:
  21.       - "3306:3306"
  22.     expose:
  23.       - "3306"
  24.     volumes:
  25.       - db-volume:/var/lib/mysql
  26.       - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  27.       - ./docker/db/configs:/etc/mysql
  28.     networks:
  29.       - backend
  30. ...
  32. volumes:
  33.   db-volume:

答案1

得分: 0

我最终通过在Dockerfile中注释掉CMD ["mysqld"]并在docker-compose.yml中将卷更改为全新的卷来使其工作。看起来是这样的：

  1. db:/var/lib/mysql

我还注释掉了

  1. #      - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  2. #      - ./docker/db/configs:/etc/mysql

所以这是最终的docker-compose.yml文件：

  1. version: "3.7"
  3. networks:
  4.   backend:
  5.     driver: ${NETWORKS_DRIVER}
  7. services:
  8.   ...
  10.   db:
  11.     image: mysqltest
  12.     container_name: db
  13.     build:
  14.       context: .
  15.       dockerfile: ./path/to/Dockerfile
  16.     restart: always
  17.     env_file:
  18.       - .env
  19.     ports:
  20.       - "3306:3306"
  21.     expose:
  22.       - "3306"
  23.     volumes:
  24.       - db:/var/lib/mysql
  25. #      - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  26. #      - ./docker/db/configs:/etc/mysql
  27.     networks:
  28.       - backend
  29. ...
  31. volumes:
  32.   db:
英文:

I finally got this working by commenting out CMD ["mysqld"] in the Dockerfile and changing the volumes to a brand new volume in the docker-compose.yml. That looks like:

  1. db:/var/lib/mysql

I also commented out

  1. #      - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  2. #      - ./docker/db/configs:/etc/mysql

So here's the final docker-compose.yml file:

  1. version: "3.7"
  3. networks:
  4.   backend:
  5.     driver: ${NETWORKS_DRIVER}
  7. services:
  8.   ...
  10.   db:
  11.     image: mysqltest
  12.     container_name: db
  13.     build:
  14.       context: .
  15.       dockerfile: ./path/to/Dockerfile
  16.     restart: always
  17.     env_file:
  18.       - .env
  19.     ports:
  20.       - "3306:3306"
  21.     expose:
  22.       - "3306"
  23.     volumes:
  24.       - db:/var/lib/mysql
  25. #      - ./docker/db/sql-scripts:/docker-entrypoint-initdb.d/
  26. #      - ./docker/db/configs:/etc/mysql
  27.     networks:
  28.       - backend
  29. ...
  31. volumes:
  32.   db:

huangapple
  • 本文由 发表于 2023年6月22日 07:15:56
  • 转载请务必保留本文链接：https://go.coder-hub.com/76527702.html
  • docker
  • docker-compose
  • mysql
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定