FROM mysql:latest

ENV MYSQL_ALLOW_PASSWORD=Samsa123# \
    MYSQL_DATABASE=KSM \
    MYSQL_HOST=192.168.55.30 \
    MYSQL_ROOT_HOST=% \
    MYSQL_USER=root

RUN /bin/bash -c "/usr/bin/mysqld_safe --skip-grant-tables &" && \
  sleep 5 && \
  mysql -u root -e "CREATE DATABASE KSM" && \
  mysql -u root KSM < ksm.sql