FROM alpine:3.7

RUN apk add --no-cache "mariadb<10.2"
    && rm -f /var/cache/apk/*

COPY mysql_start.sh /mysql_start.sh

EXPOSE 3306

CMD ["/mysql_start.sh"]

#!/bin/sh

# Atribuição de crédito!
# Arquivo baseado no original startup.sh de wangxian/alpine-mysql (Github)

if [ "$MYSQL_CHARACTER" = "" ]; then
  MYSQL_CHARACTER=utf8
fi

if [ "$MYSQL_COLLATION_SERVER" = "" ]; then
  MYSQL_COLLATION_SERVER=utf8_unicode_ci
fi

if [ "$MYSQL_PORT" = "" ]; then
  MYSQL_PORT=3306
fi

echo "=> Gerando arquivo my.cnf"
{
  echo '[mysqld]';
  echo "character-set-server = $MYSQL_CHARACTER";
  echo "collation-server = $MYSQL_COLLATION_SERVER";
  echo 'datadir = /var/lib/mysql';
  echo "port = $MYSQL_PORT";
  echo 'log-bin = /var/lib/mysql/mysql-bin';
  echo 'socket = /tmp/mysqld.sock';
  echo 'skip-host-cache';
  echo 'skip-name-resolve';
} | tee /etc/mysql/my.cnf

if [ ! -d /var/lib/mysql/mysql ]; then

  echo "=> Criando diretório de dados..."

  mysql_install_db --user=root > /dev/null

  if [ "$MYSQL_ROOT_PASSWORD" = "" ]; then
    MYSQL_ROOT_PASSWORD=root
  fi

  echo "=> Senha do usuário root definida para: $MYSQL_ROOT_PASSWORD"

  MYSQL_DATABASE=${MYSQL_DATABASE:-""}
  MYSQL_USER=${MYSQL_USER:-""}
  MYSQL_PASSWORD=${MYSQL_PASSWORD:-""}

  tfile=`mktemp`

  cat << EOF > $tfile
USE mysql;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "$MYSQL_ROOT_PASSWORD" WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
UPDATE user SET password=PASSWORD("") WHERE user='root' AND host='localhost';
EOF

  if [ "$MYSQL_DATABASE" != "" ]; then
    echo "=> Criando banco: $MYSQL_DATABASE"
    echo "CREATE DATABASE IF NOT EXISTS `$MYSQL_DATABASE` CHARACTER SET utf8 COLLATE utf8_general_ci;" >> $tfile

    if [ "$MYSQL_USER" != "" ]; then
      echo "=> Criando usuário: $MYSQL_USER com a senha: $MYSQL_PASSWORD"
      echo "GRANT ALL ON `$MYSQL_DATABASE`.* to '$MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASSWORD';" >> $tfile
    fi
  fi

  /usr/bin/mysqld --user=root --bootstrap --verbose=0 < $tfile
  rm -f $tfile
fi

exec /usr/bin/mysqld --user=root --console

version: "3.3"
services:
  mysql:
    container_name: mysql
    image: alpine:db
    environment:
      - MYSQL_ROOT_PASSWORD=root1
    volumes:
      - ./mysql/tmp:/var/lib/mysql
    restart: on-failure
    ports:
      - 3306:3306

  web:
    container_name: web
    image: php:7.2-apache
    volumes:
      - ./projeto/:/var/www
      - ./apache/:/etc/apache2/sites-enabled/
    working_dir: /var/www
    depends_on:
      - mysql
    links:
      - mysql
    restart: on-failure #always
    ports:
      - 80:80