Docker建立資料庫筆記

MySQL

https://hub.docker.com/_/mysql

Image

• Windows

docker pull mysql

• Linux

sudo docker pull mysql

Run Container

• Windows

docker run  --name docker_mysql -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 -d mysql:8.0 --default-authentication-plugin=mysql_native_password

• Linux

sudo docker run  --name docker_mysql -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 -d mysql:8.0 --default-authentication-plugin=mysql_native_password

PostgreSQL

https://hub.docker.com/_/postgres

Image

• Windows

docker pull postgres

• Linux

sudo docker pull postgres

Run Container

• Windows

docker run --name my-postgres --restart always -e POSTGRES_PASSWORD=password -d postgres

• Linux

sudo docker run --name my-postgres --restart always -e POSTGRES_PASSWORD=password -d postgres

SQL Server

快速入門：使用 Docker 執行 SQL Server Linux 容器映像

Microsoft SQL Server - Ubuntu based images

Configure SQL Server settings with environment variables on Linux-Use with Docker

Image

• Windows

docker pull mcr.microsoft.com/mssql/server:2019-latest

• Linux

sudo docker pull mcr.microsoft.com/mssql/server:2019-latest

Run Container

• Windows

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=@Passw0rd" --restart always  -p 1433:1433 --name mssql2019_1  -d mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04

• Linux

sudo docker run -e "ACCEPT_EULA=Y" -e "MSSQL_PID=Developer" -e "MSSQL_SA_PASSWORD=@Passw0rd" -e "MSSQL_COLLATION=Chinese_Taiwan_Stroke_CS_AS" --restart always -p 1433:1433 --name mssql2022_1  -d mcr.microsoft.com/mssql/server:2022-CU10-ubuntu-22.04

預設使用Developer Edition
預設定序使用Chinese_Taiwan_Stroke_CS_AS
預設SA密碼–>@Passw0rd
預計創建一般使用帳戶–>user01/user01