container run 起來之後：
PostgreSQL:
docker exec -it {db-container-name} psql -U postgres- 以預設 user
postgres連進 DB
- 以預設 user
create user {username} with password '{password}';create database {database_name} with owner {username};- 大功告成，可以用
\l列出所有 database &\du列出所有 user 來確認
- P.S. 假如一開始忘了指定 database owner 或想改變 owner:
alter database {database_name} owner to {owner_name};
MySQL: (以 5.7 為例)
- 環境變數須設置
MYSQL_ROOT_PASSWORD - docker exec -it {db-container-name} mysql -p
- 以預設 user
root連進去，輸入上面環境變數設置的密碼
- 以預設 user
create user '{username}'@'localhost' identified by '{password}';- Use
localhostdue to working on the machine with MySQL.
- Use
create database {database_name};- 確認：
show databases;SELECT user FROM mysql.user;