docker创建mysql容器失败_阳光沙滩-docker-compose创建MySQL容器失败

version: '3.1'

services:

mysql:

container_name: "sob-blog-system-mysql"

network_mode: "host"

environment:

MYSQL_ROOT_PASSWORD: "123456"

MYSQL_USER: 'root'

MYSQL_PASS: '123456'

image: "mysql:5.7.31"

restart: always

ports:

- 3306:3306

volumes:

- "/mnt/c/Users/ChengWei/docker/mysql/db:/var/lib/mysql"

- "/mnt/c/Users/ChengWei/docker/mysql/conf:/etc/mysql"

- "/mnt/c/Users/ChengWei/docker/mysql/log:/var/log/mysql"

用的是上面的docker-compose.yml,但是创建后mysql容器总是不断aborting而后重启,容器的log如下:2020-09-17 13:22:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.

2020-09-17 13:22:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2020-09-17 13:22:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.31-1debian10 started.

2020-09-17 13:22:15+00:00 [Note] [Entrypoint]: Initializing database files

2020-09-17T13:22:15.295747Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2020-09-17T13:22:15.346841Z 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive

2020-09-17T13:22:17.484906Z 0 [Warning] InnoDB: New log files created, LSN=45790

2020-09-17T13:22:17.964250Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2020-09-17T13:22:18.027924Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cf2edc2f-f8e8-11ea-a3f4-025000000001.

2020-09-17T13:22:18.046982Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

mysqld: Can't change permissions of the file 'ca-key.pem' (Errcode: 1 - Operation not permitted)

2020-09-17T13:22:18.251062Z 0 [ERROR] Could not set file permission for ca-key.pem

2020-09-17T13:22:18.251095Z 0 [ERROR] Aborting

请大家帮忙看看怎么解决这个log?

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,我可以帮您编写一个docker-compose文件来监控docker容器MySQL和网络连通性。以下是示例代码: ```yaml version: '3.7' services: prometheus: image: prom/prometheus container_name: prometheus ports: - "9090:9090" volumes: - ./prometheus.yml:/etc/prometheus/prometheus.yml command: - '--config.file=/etc/prometheus/prometheus.yml' grafana: image: grafana/grafana container_name: grafana ports: - "3000:3000" volumes: - grafana_data:/var/lib/grafana node_ping: image: grafana/grafana-image-renderer:latest container_name: node_ping environment: - PING_HOST=google.com - PING_INTERVAL=10s mysql: image: mysql:latest container_name: mysql environment: MYSQL_ROOT_PASSWORD: example_password volumes: - mysql_data:/var/lib/mysql volumes: grafana_data: mysql_data: ``` 在这个docker-compose文件中,我们定义了四个服务: - Prometheus:一个开源的监控系统,用于收集和存储监控指标数据。我们将其映射到端口9090,以便我们可以通过Web界面访问它。 - Grafana:一个开源的可视化工具,用于显示监控数据。我们将其映射到端口3000,以便我们可以通过Web界面访问它。 - Node_ping:一个用于检查网络连通性的镜像,可以通过环境变量来指定要ping的主机和ping的时间间隔。 - MySQL:一个用于存储数据的关系型数据库。 此外,我们还定义了两个卷用于持久化数据。 请注意,这只是一个示例docker-compose文件,您需要根据您的实际需求进行修改。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值