1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
FROM mysql:8.0
ENV MYSQL_ROOT_PASSWORD=root
ENV MYSQL_DATABASE=books
ADD books.sql /docker-entrypoint-initdb.d/
RUN echo "CREATE USER IF NOT EXISTS 'books'@'%' IDENTIFIED WITH mysql_native_password BY 'books123';" > /docker-entrypoint-initdb.d/01-create-user.sql && \
echo "GRANT ALL PRIVILEGES ON books.* TO 'books'@'%';" >> /docker-entrypoint-initdb.d/01-create-user.sql && \
echo "FLUSH PRIVILEGES;" >> /docker-entrypoint-initdb.d/01-create-user.sql
# Prepare general logs
RUN mkdir -p /var/log && \
touch /var/log/general.log && \
chown mysql:mysql /var/log/general.log
EXPOSE 3306
HEALTHCHECK --interval=30s --timeout=5s --start-period=5s --retries=3 \
CMD mysqladmin ping -p${MYSQL_ROOT_PASSWORD} || exit 1
# Start MySQL with general logging enabled and compatible authentication
CMD ["mysqld", "--general-log=1", "--general-log-file=/var/log/general.log"]
|
