tangjoe88/mysql-alpine repository overview

Note: mysql-alpine is the MySQL DB for JPetStore

⁠Dockerfile

FROM tangjoe88/java-alpine RUN apk --update add mariadb mariadb-client && rm -rf /var/cache/apk/* &&
sed -ri "s/^(bind-address|skip-networking|log-bin)/# \1/" /etc/mysql/my.cnf &&
mkdir -p /var/lib/mysql && chown -R mysql:mysql /var/lib/mysql COPY run.sh install-db.sh jpetstore-schema.sql jpetstore-dataload.sql / RUN chmod a+x /*.sh RUN /run.sh EXPOSE 3306 CMD ["mysqld_safe"]

⁠run.sh

#!/usr/bin/env sh set -e MYSQL_DATA_DIR="/var/lib/mysql" [ ! -d "${MYSQL_DATA_DIR}/mysql" ] && . "$(dirname "$0")/install-db.sh" chown -R mysql:mysql "$MYSQL_DATA_DIR"

⁠install-db.sh

#!/usr/bin/env sh

MYSQL_DATA_DIR="/var/lib/mysql" MYSQL_ROOT_PASSWORD="password"

echo "Running mysql_install_db ..." mysql_install_db --datadir="${MYSQL_DATA_DIR}" &>/dev/null chown -R mysql:mysql "${MYSQL_DATA_DIR}" echo "mysql_install_db completed"

mysqld_safe --datadir="${MYSQL_DATA_DIR}" & mysqladmin --silent --wait=30 ping

mysql -uroot -e
"DELETE FROM mysql.user;
CREATE USER 'root'@'%' IDENTIFIED BY '${MYSQL_ROOT_PASSWORD}';
GRANT ALL ON . TO 'root'@'%' WITH GRANT OPTION;
DROP DATABASE IF EXISTS test;
"

echo "Creating JPetStore schema ..." mysql -u root < jpetstore-schema.sql

echo "Loading JPetStore data ..." mysql -u root < jpetstore-dataload.sql

mysql -uroot -e 'FLUSH PRIVILEGES;' mysqladmin -uroot -p"${MYSQL_ROOT_PASSWORD}" shutdown

⁠How to Run

$ docker run --name jpetdb -d mysql-alpine