From 8ea568e6f84c9c14c26377643adb64134aed3d09 Mon Sep 17 00:00:00 2001
From: Charles Cabergs <me@cacharle.xyz>
Date: Sat, 17 Oct 2020 12:41:39 +0200
Subject: Added wordpress and phpmyadmin deployment/service

---
 srcs/mysql/Dockerfile        |  4 +++-
 srcs/mysql/src/entrypoint.sh | 14 ++++++++------
 srcs/mysql/src/my.cnf        |  4 ++++
 3 files changed, 15 insertions(+), 7 deletions(-)
 create mode 100644 srcs/mysql/src/my.cnf

(limited to 'srcs/mysql')

diff --git a/srcs/mysql/Dockerfile b/srcs/mysql/Dockerfile
index 0f6a2e7..4afd86f 100644
--- a/srcs/mysql/Dockerfile
+++ b/srcs/mysql/Dockerfile
@@ -4,7 +4,9 @@ RUN apk update && \
     apk upgrade && \
 	apk add mysql mysql-client --no-cache
 
-COPY ./src /root
+
+COPY src/entrypoint.sh /root/entrypoint.sh
+COPY src/my.cnf /etc/my.cnf
 
 EXPOSE 3306
 
diff --git a/srcs/mysql/src/entrypoint.sh b/srcs/mysql/src/entrypoint.sh
index 67f705b..8d7c1d1 100755
--- a/srcs/mysql/src/entrypoint.sh
+++ b/srcs/mysql/src/entrypoint.sh
@@ -2,14 +2,16 @@
 
 mkdir -vp /run/mysqld
 
-echo -e 'asdfasdf123\nasdfasdf123\n' | adduser cacharle
+# echo -e 'asdfasdf123\nasdfasdf123\n' | adduser cacharle
 
-mysql_install_db --user=cacharle
+# export MYSQL_ROOT_PASSWORD=''
 
-/usr/bin/mysqld --user=cacharle --skip-password --bootstrap <<EOF
+mysql_install_db --datadir=/usr/lib/data --user=root
+
+/usr/bin/mysqld --user=root --bootstrap <<EOF
 CREATE DATABASE wordpressdb;
-CREATE USER 'cacharle'@'localhost' IDENTIFIED BY 'pass';
-GRANT ALL PRIVILEGES ON wordpressdb.* TO 'cacharle'@'localhost';
+CREATE USER 'root'@'localhost' IDENTIFIED BY 'pass';
+GRANT ALL PRIVILEGES ON wordpressdb.* TO 'root'@'localhost';
 IDENTIFIED BY 'pass';
 FLUSH PRIVILEGES;
 EOF
@@ -17,4 +19,4 @@ EOF
 # until mysql; do
 # sleep 5
 
-/usr/bin/mysqld --user=cacharle
+exec /usr/bin/mysqld --user=root --console
diff --git a/srcs/mysql/src/my.cnf b/srcs/mysql/src/my.cnf
new file mode 100644
index 0000000..5517925
--- /dev/null
+++ b/srcs/mysql/src/my.cnf
@@ -0,0 +1,4 @@
+[mysqld]
+user=root
+port=3306
+datadir=/usr/lib/data
-- 
cgit