X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fmysql%2Fbin%2Fcreatedb;h=adc6ecdb42a88aa6720ad704edfa83050bc8896e;hb=22f04b9fac14adc3d3fc98273ba126c3a51792c3;hp=582051b51782a82fea39d0b643a680b10925944b;hpb=5ce6d51b9c15b2e316d60fad4ecfa1ea1b32bf7b;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