Docker-compose update db password

Docker-compose REDIS UPDATE PASSWD

docker-comepose启动redis

command有两种方式

• 一种是requirepass
• 一种是redis.conf

update password

• requirepass
  直接修改docker-compose.yml文件
• redis.conf
  修改配置文件redis.conf

执行命令：
docker-comepose up  -d
1
2

Docker-compose RABBITMQ UPDATE PASSWD

docker-compose启动rabbitmq

version: '3.8'

services:
  redis:
    image: redis:6.2.4
    container_name: redis
    restart: always
    ports:
      - 6379:6379
    volumes:
#      - ./redis.conf:/usr/local/etc/redis/redis.conf
      - /data/tw/redis:/data
    command:
      /bin/bash -c "redis-server --save 20 1 --loglevel warning --requirepass xxxxxxx"
#   redis-server /usr/local/etc/redis/redis.conf
    privileged: true
    networks:
      network:
        ipv4_address: 10.253.1.4

networks:
  network:
    driver: bridge
    ipam:
      config:
      - subnet: 10.253.1.0/24
    name: docker_test_net

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

修改密码

登录docker
rabbitmqctl list_users
rabbitmqctl change_password username passwd
验证
localhost:15672
使用新密码登录
1
2
3
4
5
6

执行命令：
docker-comepose up  -d
1
2

Docker-compose MONGODB UPDATE PASSWD

docker-compose启动mongodb

version: '3.8'
networks:
  network:
    driver: bridge
    ipam:
      config:
      - subnet: 10.253.1.0/24
    name: docker_test_net
services:
  mongo:
    command: mongod --logpath=/var/log/mongodb/mongodb.log --logappend
    container_name: mongo
    environment:
      MONGO_INITDB_ROOT_PASSWORD: xxxxxxxxxxxxx
      MONGO_INITDB_ROOT_USERNAME: root
      TZ: Asia/Shanghai
    image: mongo:4.4.6
    networks:
      network:
        ipv4_address: 10.253.1.3
    privileged: true
    ports:
    - published: 27017
      target: 27017
    restart: always
    volumes:
    - $(pwd)mongodb/:/data/db:rw

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

修改密码

登录docker
mongo
use admin
db.auth('user','passwd')
db.changeUserPassword('root','passwd')
exit
验证
mongo
使用新密码登录
1
2
3
4
5
6
7
8
9

执行命令：
docker-comepose up  -d
1
2

Docker-compose POSTGRES13 UPDATE PASSWD

docker-compose启动postgres

version: '3.8'

services:
  postgres:
    image: postgres:13.0
    container_name: postgres
    restart: always
    ports:
      - 5432:5432
    volumes:
      - /data/tw/postgres:/var/lib/postgresql/data
    privileged: true
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: 123456
      POSTGRES_DB: postgres
      TZ: Asia/Shanghai
      PGTZ: Asia/Shanghai 
    networks:
      network:
        ipv4_address: 10.253.1.6

networks:
  network:
    driver: bridge
    ipam:
      config:
      - subnet: 10.253.1.0/24
    name: docker_test_net
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

修改密码

登录docker
 psql -U postgres
du+
                                     List of roles
 Role name |                   Attributes                    | Member of | Descripti
on 
-----------+-------------------------------------------------+-----------+----------
---
 admin_sys | Superuser                                       | {}        | 
 postgres  | Create role, Create DB, Replication, Bypass RLS | {}        | 
 #方法一
 ALTER USER postgres WITH PASSWORD 'Y4wzDZfKpdaARq@dsd';
ERROR:  must be superuser to alter replication users
#方法二
 \password postgres 
Enter new password: 
Enter it again: 
ERROR:  must be superuser to alter replication users
 \q

psql -U admin_sys
psql: error: could not connect to server: FATAL:  database "admin_sys" does not exis
 psql -Uadmin_sys postgres -h localhost
psql (13.0 (Debian 13.0-1.pgdg100+1))
Type "help" for help.

postgres=# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 tw5000    | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
(4 rows)

postgres=# \password postgres 
Enter new password: 
Enter it again: 
postgres=# exit

postgres
使用新密码登录
# TIPS
**ps** ： 命令行修改之后，无论是否变更docker-compose.yml，在未删除持久化数据之前，都是新密码生效
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47