3 files changed, 31 insertions, 0 deletions
diff --git a/srcs/mysql/Dockerfile b/srcs/mysql/Dockerfile
new file mode 100644
index 0000000..f863eeb
--- /dev/null
+++ b/srcs/mysql/Dockerfile
@@ -0,0 +1,18 @@
+FROM alpine:3.10
+
+ENV MYSQL_ROOT_PASSWORD root
+ENV MYSQL_DATABASE ft_services_db
+ENV MYSQL_USER ft_services_user
+ENV MYSQL_PASSWORD ft_services_password
+ENV MYSQL_USER_MONITORING monitoring
+ENV MYSQL_PASSWORD_MONITORING monitoring
+
+RUN apk update && \
+	apk add --no-cache mysql-client
+COPY ./scripts /root/scripts
+
+EXPOSE 3306
+
+# RUN /root/scripts/setup_mysql.sh
+
+CMD ["mysql"]
diff --git a/srcs/mysql/scripts/setup_mysql.sh b/srcs/mysql/scripts/setup_mysql.sh
new file mode 100755
index 0000000..56f767f
--- /dev/null
+++ b/srcs/mysql/scripts/setup_mysql.sh
@@ -0,0 +1,8 @@
+#!/bin/sh
+
+addgroup mysql mysql
+
+MYSQLD_DIR=/run/mysqld
+
+mkdir $MYSQLD_DIR
+chown mysql:mysql $MYSQL_DIR
diff --git a/srcs/mysql/scripts/setup_mysql_db.sql b/srcs/mysql/scripts/setup_mysql_db.sql
new file mode 100755
index 0000000..ea66998
--- /dev/null
+++ b/srcs/mysql/scripts/setup_mysql_db.sql
@@ -0,0 +1,5 @@
+CREATE DATABASE wordpressdb;
+CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspass';
+GRANT ALL PRIVILEGES ON wordpressdb.* TO 'wordpressuser'@'localhost'
+IDENTIFIED BY 'wordpresspass';
+FLUSH PRIVILEGES;