#!/bin/bash

sudo docker pull phpmyadmin/phpmyadmin
sudo docker pull mysql:5.7.24

sudo docker network create mysql-network

sudo docker run --name a-mysql \
  --net=mysql-network \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=password \
  -d mysql:5.7.24

sudo docker run --name a-mysql-admin \
  --net=mysql-network \
  -e MYSQL_ROOT_PASSWORD=password \
  -e PMA_HOST="a-mysql" \
  -e PMA_PORT=3306 \
  -p 8080:80 \
  -d phpmyadmin/phpmyadmin

echo "mysql: " $(sudo docker inspect --format '{{ index .NetworkSettings.Networks "mysql-network" "IPAddress"}}' a-mysql)
echo "username: root"
echo "password: password"
echo "phpmyadmin: " $(sudo docker inspect --format '{{ index .NetworkSettings.Networks "mysql-network" "IPAddress"}}' a-mysql-admin)