mysql-init-script

mysql-init-script

cat << EOF > mysql-init-script.sh

#if ibdata exists, simply start mysql
if [ -f /var/lib/mysql/ibdata1  ] ;then
    /usr/bin/mysqld_safe
#if not, initialize db and re-grant permissions    
else
     /usr/bin/mysql_install_db && \
      /usr/bin/mysqld_safe
     /usr/bin/mysql -uroot -e "GRANT ALL ON *.* TO admin@'%' IDENTIFIED BY 'admin' WITH GRANT OPTION; FLUSH PRIVILEGES" 
fi
EOF

new_dockerfile

FROM ubuntu

RUN apt-get update
RUN apt-get upgrade -y
RUN apt-get -y install mysql-client mysql-server
RUN sed -i -e"s/^bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/" /etc/mysql/my.cnf

ADD ./mysql-init-script.sh /tmp/mysql-init-script.sh

EXPOSE 3306

CMD ["/bin/bash -c /tmp/mysql-init-script.sh"]