zerolabssyseng/mysql repository overview

IMAGE = zerolabssyseng/mysql

clean-local:
	docker rmi $(CLEAN_OPTIONS) $(IMAGE):$(TAG) || true

build:
	docker build $(BUILD_OPTIONS) --build-arg TAG=${TAG} -t $(IMAGE):$(TAG) .

pull:
	docker pull $(PULL_OPTIONS) $(IMAGE):$(TAG)

push: build
	docker push $(PUSH_OPTIONS) $(IMAGE):$(TAG)

make [options]:
    clean-local
    build
    pull
    push

ARG TAG

FROM zerolabssyseng/base-consul:${TAG:-latest}
MAINTAINER "System Engineer (SysEng)"

ENV MYSQL_PROFILE="my-medium" \
    MYSQL_ROOT_HOST="localhost" \
    MYSQL_ROOT_PASSWORD="password" \
    MYSQL_DATABASE="mysql-data" \
    MYSQL_USERNAME="admin" \
    MYSQL_PASSWORD="password" \
    MYSQL_HOST="localhost"

RUN mkdir -p /var/lib/mysql && \
    addgroup -S mysql && \
    adduser -S -D -g "" -G mysql -s /sbin/nologin -h /var/lib/mysql mysql && \
    chown mysql:mysql /var/lib/mysql

RUN apk add --update mysql mysql-client && \
    mkdir -p /var/run/mysqld && \
    chown -R mysql:root /var/run/mysqld && \
    rm -rf /var/cache/apk/*

COPY rootfs/ /

RUN touch /mysql-init-complete && chmod 777 /mysql-init-complete

ENTRYPOINT [ "/init" ]

HEALTHCHECK CMD /healthycheck.sh

EXPOSE 3306
CMD [ "mysqld" ]

VOLUME [ "/var/lib/mysql" ]

version: '3.5'

volumes:
    mysql:

services:
    mysql:
        image: zerolabssyseng/mysql:latest
        ports:
            - "3306:3306"
        volumes:
            - /etc/localtime:/etc/localtime:ro
            - ./data/mysql:/var/lib/mysql         # volume for data
        environment:
            - ENV=local                             # environment name
            #- MYSQL_TEMPLATE=generic             # configuration template

            #
            # template generic
            #

            #- MYSQL_PROFILE=my-small             # default configuration profile to use (my-small, my-medium ...)
            #- MYSQL_ROOT_PASSWORD=mysql        # root password (optional)
            #- MYSQL_ROOT_HOST=localhost          # root user hostmask (optional)
            #- MYSQL_DATABASE=                    # create user database (optional)
            #- MYSQL_USERNAME=                    # user name
            #- MYSQL_PASSWORD=                    # user password
            #- MYSQL_HOST=                        # user hostmask