X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;ds=sidebyside;f=etc%2Fmysql%2Fbin%2Fcreatedb;fp=etc%2Fmysql%2Fbin%2Fcreatedb;h=582051b51782a82fea39d0b643a680b10925944b;hb=5ce6d51b9c15b2e316d60fad4ecfa1ea1b32bf7b;hp=0000000000000000000000000000000000000000;hpb=2e5bb0ff5df2b7a5d527a4f896b802df31d3c6bc;p=lhc%2Fateliers.git

diff --git a/etc/mysql/bin/createdb b/etc/mysql/bin/createdb
new file mode 100755
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