# file KLEIDER/web/src/localization/MySQLLookup_users.sql
# 2020-04-01 Herbert Schiemann <h.schiemann@herbaer.de>
# Legt die Benutzer der Datenbanken "translate" und "translrnbuf" an.

USE mysql;
DELETE FROM user WHERE user = '${mysql.translate.user}';
INSERT INTO user
       (user, host, password)
       VALUES (
              '${mysql.translate.user}',
              'localhost',
              PASSWORD('${mysql.translate.password}')
       );
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON translate.* TO ${mysql.translate.user}@localhost;

DELETE FROM user WHERE user = '${mysql.translrnbuf.user}';
INSERT INTO user
       (user, host, password)
       VALUES (
              '${mysql.translrnbuf.user}',
              'localhost',
              PASSWORD('${mysql.translrnbuf.password}')
       );
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON translrnbuf.* TO ${mysql.translrnbuf.user}@localhost;

# end of file KLEIDER/web/src/localization/MySQLLookup_users.sql
