blob: d4e1b453f073ca39ff1e293eec582fdb7ff064da (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
|
