도커로 DB 컨테이너 실행하기

Maria

$ docker pull mariadb:latest
$ docker run -p <port>:3006 --name <container_name> -e MYSQL_ROOT_PASSWORD=<password> -e MYSQL_DATABASE=<database> mariadb

or

$ docker run -p <port>:3006 --name <container_name> -e MYSQL_ROOT_PASSWORD=<password> -e MYSQL_DATABASE=<database> mariadb:latest

접속정보

host: localhost:

port: <port>

database: <database>

username: root

password: <password>

 

Mysql

$ docker pull mysql:8.0.22
$ docker run --name <container_name> -e MYSQL_ROOT_PASSWORD=<password> -d -p <port>:3306 mysql

or

$ docker run --name <container_name> -e MYSQL_ROOT_PASSWORD=<password> -d -p <port>:3306 mysql:latest

$ docker exec -itu 0 <container_id> /bin/bash
# mysql -u root -p
Enter password: <password>
mysql> create database <database>;

접속정보

host: localhost:

port: <port>

database: <database>

username: root

password: <password>

 

DB2

$ docker run -itd --name <container_name> --privileged=true -p <port>:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=<password> -e DBNAME=<database> ibmcom/db2

접속정보

host: localhost:

port: <port>

database: <database>

username: db2inst1

password: <password>

 

Oracle

docker run --name <container_name> -d -p <port>:1521 jaspeen/oracle-xe-11g

접속정보

host: localhost

port: <port>

database: XE

username: system

password: oracle

 

MongoDB

$ docker pull mongo
$ docker run --name <container_name> -d -p <port>:27017 mongo

or

$ docker run --name <container_name> -d -p <port>:27017 mongo

$ docker exec -itu 0 <container_id> /bin/bash
# mongo
> use <database>
db.createUser({
	user: <username>,
    pwd: <password>,
    roles: ["readWrite"]
});

접속정보

host: localhost

port: <port>

authenticationDatabase: <database>

database: <database>

username: <username>

password: <password>