X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fsv%2Fmysql%2Fconfigure.sh;h=2c00148510958726e0f09b0148e82395cf54f670;hb=45a4450db64a63643edd37d8e3aba8d57fe6a3ad;hp=cf8e41dcd97859da1555afc77ef5a82890ced26e;hpb=9655fd306f6c9b4741af7e355867e1c0c5f65728;p=lhc%2Fateliers.git

diff --git a/etc/sv/mysql/configure.sh b/etc/sv/mysql/configure.sh
index cf8e41d..2c00148 100644
--- a/etc/sv/mysql/configure.sh
+++ b/etc/sv/mysql/configure.sh
@@ -69,7 +69,7 @@ sudo mysql -u root --batch --verbose <<-EOF
 	DELETE FROM mysql.user WHERE user = 'root' and plugin = '';
 	DROP PROCEDURE IF EXISTS mysql.create_user_mysql;
 	DELIMITER //
-		CREATE PROCEDURE mysql.create_user_mysql ()
+	CREATE PROCEDURE mysql.create_user_mysql ()
 			BEGIN
 				IF NOT (EXISTS (SELECT User
 					FROM mysql.user
@@ -85,5 +85,20 @@ sudo mysql -u root --batch --verbose <<-EOF
 	UPDATE mysql.user SET grant_priv='Y',super_priv='Y' WHERE user='mysql';
 	DELETE FROM mysql.db   WHERE user = '';
 	DELETE FROM mysql.user WHERE user = '';
+	DROP PROCEDURE IF EXISTS mysql.create_user;
+	CREATE PROCEDURE mysql.create_user (username VARCHAR(16), hostname VARCHAR(60))
+			BEGIN
+				IF NOT (EXISTS (SELECT User
+					FROM mysql.user
+					WHERE User = username
+					AND Host = hostname
+					LIMIT 1))
+				 THEN
+					SET @QUERY = CONCAT("CREATE USER ", username, "@", hostname, " IDENTIFIED WITH auth_socket");
+					PREPARE stmt FROM @QUERY;
+					EXECUTE stmt;
+				 END IF;
+			 END;
+	 //
 	FLUSH PRIVILEGES;
 	EOF