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

diff --git a/etc/sv/mysql/configure.sh b/etc/sv/mysql/configure.sh
index cf8e41d..c576325 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,21 @@ 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;
+	 //
+	DROP PROCEDURE IF EXISTS mysql.show_user;
 	FLUSH PRIVILEGES;
 	EOF