From f128d6470b18ef8fff4e6ce0b269b2b673ab91ca Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Sat, 22 Feb 2020 05:03:12 +0100
Subject: mysql base (WIP), nginx config from ft_server

---
 srcs/mysql/scripts/setup_mysql.sh     | 8 ++++++++
 srcs/mysql/scripts/setup_mysql_db.sql | 5 +++++
 2 files changed, 13 insertions(+)
 create mode 100755 srcs/mysql/scripts/setup_mysql.sh
 create mode 100755 srcs/mysql/scripts/setup_mysql_db.sql

(limited to 'srcs/mysql/scripts')

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;
-- 
cgit