local/mysql-user-create

   1 #!/bin/sh -eu
   2 tool=$(readlink -e "${0%/*}/..")
   3 . "$tool"/local/lib.sh
   4
   5 user="$1"
   6 sudo -u mysql mysql -u mysql --batch --verbose <<-EOF
   7         DROP PROCEDURE IF EXISTS mysql.create_user;
   8         DELIMITER //
   9         CREATE PROCEDURE mysql.create_user (username VARCHAR(16), hostname VARCHAR(60))
  10          BEGIN
  11                 IF NOT (EXISTS (SELECT User
  12                         FROM mysql.user
  13                         WHERE User = username
  14                         AND   Host = hostname
  15                         LIMIT 1))
  16                 THEN
  17                         SET @QUERY = CONCAT("CREATE USER ", username, "@", hostname, " IDENTIFIED WITH auth_socket");
  18                         PREPARE stmt FROM @QUERY;
  19                         EXECUTE stmt;
  20                  END IF;
  21          END;
  22          //
  23         CALL mysql.create_user('$user', 'localhost');
  24         EOF
  25 sudo adduser "$user" mysql-data