docker-compose mysql snippet

README.md

MySQL Snippets

$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:5.7.27

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON 'database'.* TO 'database'@'localhost';
FLUSH PRIVILEGES;

Postgres Snippets

docker run -e PGADMIN_DEFAULT_EMAIL=root@example -e PGADMIN_DEFAULT_PASSWORD=password -p 80:80 --rm dpage/pgadmin4

docker-compose-mysql.yml

version: '3.7'

services:

  mysql:
    image: mysql:5.7.27
    restart: always
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: example

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080