Modification : vm_hosted -> etc/sv/*/configure.sh .

[lhc/ateliers.git] / etc / mysql / bin / createdb

diff --git a/etc/mysql/bin/createdb b/etc/mysql/bin/createdb
new file mode 100755 (executable)
index 0000000..582051b
--- /dev/null
+++ b/etc/mysql/bin/createdb
@@ -0,0 +1,9 @@
+#!/bin/sh -eux
+db="$1"
+user="$2"
+sudo -u mysql mysql --batch <<-EOF
+       DROP   DATABASE IF EXISTS $db;
+       CREATE DATABASE $db CHARACTER SET utf8 COLLATE utf8_general_ci;
+       GRANT ALL PRIVILEGES ON $base.* TO '$user'@'localhost' IDENTIFIED WITH auth_socket;
+       FLUSH PRIVILEGES;
+       EOF