more mysql stuff

2 files changed, 26 insertions, 0 deletions

diff --git a/lib/60-mysql b/lib/60-mysql
new file mode 100644
index 0000000..1d2f158
--- /dev/null
+++ b/lib/60-mysql
@@ -0,0 +1,25 @@
+#!/bin/sh
+
+mysql_run(){
+  MYSQL_PWD="$boxconf_password" mysql \
+    --batch \
+    --ssl-verify-server-cert \
+    --user="$boxconf_username" \
+    "$@"
+}
+
+mysql_create_user(){
+  # $1 = mysql_host, $2 = username $3 = via
+  cat <<EOF | mysql_run --host="${1}"
+CREATE USER IF NOT EXISTS '${2}' IDENTIFIED VIA ${3};
+EOF
+}
+
+mysql_create_database(){
+  # $1 = mysql_host, $2 = dbname, $3 = owner $4 = options
+  cat <<EOF | mysql_run --host="${1}"
+CREATE DATABASE IF NOT EXISTS ${2} ${4:-};
+GRANT ALL PRIVILEGES ON ${2}.* TO '${3}';
+FLUSH PRIVILEGES;
+EOF
+}
diff --git a/lib/60-postgres b/lib/60-postgres
index 6f418ea..b50d130 100644
--- a/lib/60-postgres
+++ b/lib/60-postgres
@@ -9,6 +9,7 @@ postgres_run(){
     -v ON_ERROR_STOP=1 \
     "$@"
 }
+
 postgres_create_role(){
   # $1 = postgres_host, $2 = username
   cat <<EOF | postgres_run -h "${1}" -d postgres