From 95b7f564247d2e3a2e7dc051bf3366f7542e48ef Mon Sep 17 00:00:00 2001 From: Ludovic CHEVALIER Date: Tue, 16 Apr 2013 17:05:28 +0200 Subject: [PATCH] Modifications : etc/sv/mysql/configure.sh --- etc/sv/mysql/configure.sh | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) 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 -- 2.20.1