aboutsummaryrefslogtreecommitdiff
path: root/srcs/mysql/scripts
diff options
context:
space:
mode:
Diffstat (limited to 'srcs/mysql/scripts')
-rwxr-xr-xsrcs/mysql/scripts/setup_mysql.sh8
-rwxr-xr-xsrcs/mysql/scripts/setup_mysql_db.sql5
2 files changed, 13 insertions, 0 deletions
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;