Merge branch 'main' of db:dotfiles

1 files changed, 25 insertions, 0 deletions

diff --git a/bin/extra/mariadb-adduser b/bin/extra/mariadb-adduser
new file mode 100755
index 0000000..d4e1b45
--- /dev/null
+++ b/bin/extra/mariadb-adduser
@@ -0,0 +1,25 @@
+#!/bin/sh
+if [ "$(id -u)" -ne 0 ]
+then
+	>&2 printf "Not root.\n"
+	exit 1
+fi
+
+printf 'name? '
+name="$(head -n 1)"
+printf 'password? '
+password="$(head -n 1)"
+printf 'database? '
+database="$(head -n 1)"
+
+(
+    cat <<EOF
+    CREATE USER '$name'@'%' IDENTIFIED BY '$password';
+EOF
+    [ "$database" ] && cat <<EOF
+    GRANT ALL PRIVILEGES ON `$database`.* TO '$name'@'%' WITH GRANT OPTION;
+    CREATE DATABASE `$database`;
+    FLUSH PRIVILEGES;
+EOF
+
+) | mariadb