Modifications : etc/sv/mysql/configure.sh

diff --git a/etc/sv/mysql/configure.sh b/etc/sv/mysql/configure.sh
index cf8e41d..c576325 100644 (file)
--- 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