duanfangwei/centos-mysql-cm repository overview

FROM centos:7.7.1908
MAINTAINER "daniel duan"
ARG MYSQL_SERVER_PACKAGE=mysql-community-server-5.7.29

RUN groupadd -r mysql && useradd -r -g mysql mysql
RUN yum install -y https://repo.mysql.com/mysql57-community-release-el7.rpm  \
    && yum install -y $MYSQL_SERVER_PACKAGE  \
    && yum clean all \
    && mkdir /docker-entrypoint-initdb.d

RUN  echo "user=mysql" >> /etc/my.cnf
VOLUME /var/lib/mysql

COPY ./docker-entrypoint.sh /usr/local/bin/entrypoint.sh
COPY ./healthcheck.sh /usr/local/bin/healthcheck.sh
RUN chmod +x /usr/local/bin/entrypoint.sh /usr/local/bin/healthcheck.sh
ENTRYPOINT ["/usr/local/bin/entrypoint.sh"]
HEALTHCHECK CMD /usr/local/bin/healthcheck.sh
EXPOSE 3306 33060
CMD ["mysqld"]

create database cm default character set utf8;
grant all privileges on cm.* to 'cm'@'%' identified by '123456';
create database hive default character set utf8;
grant all privileges on hive.* to 'hive'@'%' identified by '123456';
create database oozie default character set utf8;
grant all privileges on oozie.* to 'oozie'@'%' identified by '123456';
create database hue default character set utf8;
grant all privileges on hue.* to 'hue'@'%' identified by '123456';