#install LA-MariaDB-PP
#Setting mysql variables
ENV MYSQL_USER='root'
ENV MYSQL_PASSWORD='root'
ENV MYSQL_DATA_DIR='/var/lib/mysql'
ENV MYSQL_RUN_DIR='/run/mysqld'
ENV MYSQL_LOG_DIR='/var/log/mysql'
## Make apt and MySQL happy with the docker environment
  RUN echo "#!/bin/sh\nexit 101" >/usr/sbin/policy-rc.d  && \
      chmod +x /usr/sbin/policy-rc.d && \
      groupadd -r mysql && useradd -r -g mysql mysql
	# set installation parameters to prevent the installation script from asking
  RUN echo "mysql-server mysql-server/root_password password $MYSQL_PASSWORD" | debconf-set-selections && \
      echo "mysql-server mysql-server/root_password_again password $MYSQL_PASSWORD" | debconf-set-selections

RUN apt-get install mariadb-server mariadb-client -yqq
RUN update-rc.d mysql defaults

RUN mkdir -p $MYSQL_DATA_DIR
RUN usermod -d $MYSQL_DATA_DIR mysql

RUN echo "[mysqld]" >> /etc/mysql/my.cnf && \
    echo "bind-address = 127.0.0.1" >> /etc/mysql/my.cnf && \
    echo "datadir = $MYSQL_DATA_DIR" >> /etc/mysql/my.cnf

    RUN sed -i 's/^\(log_error\s.*\)/# \1/' /etc/mysql/my.cnf && \
        echo "mysqld_safe &" > /tmp/config && \
        echo "mysqladmin --silent --wait=10 ping || exit 1" >> /tmp/config && \
        echo "mysql -e 'GRANT ALL PRIVILEGES ON *.* TO \"root\"@\"%\" WITH GRANT OPTION;'" >> /tmp/config && \
        echo "mysql -e 'GRANT ALL ON *.* TO \"$MYSQL_USER\"@\"%\" IDENTIFIED BY \"$MYSQL_PASSWORD\" WITH GRANT OPTION; FLUSH PRIVILEGES;'" >> /tmp/config && \
    bash /tmp/config && \
    rm -f /tmp/config

# MariaDB - test - bash
## service mysql start
## service mysql status