X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fmysql%2Fbin%2Fcreatedb;fp=etc%2Fmysql%2Fbin%2Fcreatedb;h=adc6ecdb42a88aa6720ad704edfa83050bc8896e;hb=7162111397558c874a76b510aa16954dfc566a37;hp=582051b51782a82fea39d0b643a680b10925944b;hpb=07f867bc5dc0e3bb3d01ceef80ce434e96642cba;p=lhc%2Fateliers.git

diff --git a/etc/mysql/bin/createdb b/etc/mysql/bin/createdb
index 582051b..adc6ecd 100755
--- a/etc/mysql/bin/createdb
+++ b/etc/mysql/bin/createdb
@@ -1,9 +1,6 @@
 #!/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;
+user="${2:-$1}"
+sudo -u mysql mysql --batch --verbose <<-EOF
+	CALL mysql.create_database('$db', '$user', 'localhost');
 	EOF