docker修改postgresql密码
Last login: Wed Sep9 09:19:46 on ttys002The default interactive shell is now zsh.To update your account to use zsh, please run `chsh -s /bin/zsh`.For more details, please visit https://support.apple.c
·
Last login: Wed Sep 9 09:19:46 on ttys002
The default interactive shell is now zsh.
To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
bogon:~ xiwenlu$ ssh root@00.00.00.0
root@00.00.00.0's password:
Last login: Wed Sep 9 09:20:32 2020 from 00.00.00.0
[root@VM-0-10-centos ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
eeadee04137b nginx "/docker-entrypoint.…" 41 hours ago Up 41 hours 0.0.0.0:80->80/tcp nginx-test-web
de700cb36f69 jenkinsci/blueocean "/sbin/tini -- /usr/…" 45 hours ago Up 41 hours 0.0.0.0:8080->8080/tcp, 0.0.0.0:50000->50000/tcp serene_wiles
ec2143b01d5a postgres:9.6 "docker-entrypoint.s…" 46 hours ago Up 12 minutes 0.0.0.0:5432->5432/tcp postgres
[root@VM-0-10-centos ~]# docker exec -it ec2143b01d5a bash
root@ec2143b01d5a:/# su postgres
postgres@ec2143b01d5a:/$ psql
psql (9.6.19)
Type "help" for help.
postgres=# ALTER USER postgres WITH PASSWORD '123456';
ALTER ROLE
postgres=# \q
postgres@ec2143b01d5a:/$
- 进入容器:docker exec -it ec2143b01d5a bash
- 使用postgres登录:su postgres
- 连接数据库:psql -U postgres
- 修改postgres用户密码:Alter user postgres with password ‘123456’;
- 退出数据库连接:\q
更多推荐
已为社区贡献1条内容
所有评论(0)