Skip to content

acnaweb/database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 

Repository files navigation

Database

Running databases in container

Pre req

Databases

Postgres

docker run -d \
    --name postgres \
    --rm \
    -e POSTGRES_USER=new_user \
    -e POSTGRES_PASSWORD=my_pwd \
    -p 5432:5432 \
    postgres

MySQL

docker run -d \
    --name mysql \
    --rm \
    -e MYSQL_ROOT_PASSWORD=root_pwd \
    -e MYSQL_USER=new_user \
    -e MYSQL_PASSWORD=my_pwd \
    -p 3306:3306 \
    mysql

SQL Server

MSSQL_SA_PASSWORD -> 8 characters of at least three of these four categories: uppercase letters, lowercase letters, numbers and non-alphanumeric symbols

docker run -d \
    --name sqlserver \
    --rm \
    -e MSSQL_SA_PASSWORD=1q2w3e4R@ \
    -e "ACCEPT_EULA=Y" \
    -p 1433:1433 \
    mcr.microsoft.com/mssql/server:latest 

Oracle

  • Efetuar login no Registry
docker login container-registry.oracle.com
  • Pull da imagem
docker pull container-registry.oracle.com/database/free:latest
  • Run
docker run -d \
    --name oracle \
    --rm \
    -e ORACLE_PWD=manager \
    -e ORACLE_CHARACTERSET=AL32UTF8 \
    -p 1521:1521 \
    -p 5500:5500 \
    container-registry.oracle.com/database/free:latest
  • Exemplo de criação de usuário "Developer" com a senha "Manager"
ALTER SESSION SET "_ORACLE_SCRIPT"=true;

CREATE USER developer
IDENTIFIED BY manager
DEFAULT TABLESPACE users
QUOTA UNLIMITED on users;

GRANT create session TO developer;
GRANT resource TO developer;

Neo4J

MongoDB

Info: Mongo Client https://www.mongodb.com/pt-br/products/tools/compass

docker run -d \
    --name mongodb \
    --rm \
    -e MONGO_INITDB_ROOT_USERNAME=mongo \
    -e MONGO_INITDB_ROOT_PASSWORD=root_pwd \
    -p 27017:27017 \
    mongo

SQL Client

DBeaver

SQuirrel SQL

SQL Developer/Oracle

About

Databases running in containers

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published