From: Ludovic CHEVALIER <ludovic.chevalier@heureux-cyclage.org>
Date: Tue, 16 Apr 2013 15:05:28 +0000 (+0200)
Subject: Modifications : etc/sv/mysql/configure.sh
X-Git-Url: http://git.cyclocoop.org/?p=lhc%2Fateliers.git;a=commitdiff_plain;h=95b7f564247d2e3a2e7dc051bf3366f7542e48ef

Modifications : etc/sv/mysql/configure.sh
---

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