你好，首先感谢你的辛勤工作，做出这个项目。我在尝试能修改docker部署的mysql密码，修改后部署，但是在install之后，重启容器，webstack-go-

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

请问如何修改docker部署的mysql的密码 about webstack-go HOT 5 CLOSED

ch3nnn commented on August 16, 2024

请问如何修改docker部署的mysql的密码

from webstack-go.

Comments (5)

yuzebin commented on August 16, 2024

补充一下：修改了两个文件：
docker-compose.yml
configs/docker-configs.toml

from webstack-go.

ch3nnn commented on August 16, 2024

补充一下：修改了两个文件： docker-compose.yml configs/docker-configs.toml

了解, 可以把具体修改地方粘出来。我自己试了是正常运行的, 部署前可以把之前创建的容器删掉重新部署。

configs/docker-configs.toml 修改 mysql.read 和 mysql.write pass 字段

[mysql]

  [mysql.base]
    connmaxlifetime = 60
    maxidleconn = 60
    maxopenconn = 10

  [mysql.read]
    addr = "webstack-go-mysql:3306"
    name = "webstack-go"
    pass = "abc123123"
    user = "root"

  [mysql.write]
    addr = "webstack-go-mysql:3306"
    name = "webstack-go"
    pass = "abc123123"
    user = "root"

docker-compose.yml 修改 MYSQL_ROOT_PASSWORD 字段

  webstack-go-mysql:
    image: mysql/mysql-server:5.7
    container_name: webstack-go-mysql
    environment:
      MYSQL_DATABASE: webstack-go
      TZ: Asia/Shanghai
      # 允许来自其他主机的根连接
      # https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html#docker_var_mysql-root-host
      MYSQL_ROOT_HOST: "%"
      MYSQL_ROOT_PASSWORD: abc123123
    ports:
      - "3306:3306"
    networks:
      - webstack-go
    healthcheck:
      test: [ "CMD", "mysqladmin" ,"ping", "-h", "localhost" ]
      <<: *healthcheck_defaults

from webstack-go.

yuzebin commented on August 16, 2024

感谢你的及时回复，我有空再尝试一下。

顺带说一下，我的目的是增强mysql的安全性，我换了一个方法，同样达到了目的：
只监听宿主机的127.0.0.1，不监听公网ip，同样可以增强安全性：
ports:
- "127.0.0.1:3306:3306"

from webstack-go.

ch3nnn commented on August 16, 2024