summaryrefslogtreecommitdiffstats
path: root/root-galera/usr/share/container-scripts/mysql/init/50-galera-passwd-change.sh
blob: 2844d5feaa6149e54bb3016280d0726454d227c3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
#!/bin/bash

password_change() {
mysql $mysql_flags <<EOSQL
    CREATE USER IF NOT EXISTS '${MYSQL_GALERA_USER}'@'localhost';
    SET PASSWORD FOR '${MYSQL_GALERA_USER}'@'localhost' = PASSWORD('${MYSQL_GALERA_PASSWORD}');
    GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO '${MYSQL_GALERA_USER}'@'localhost';
    UPDATE mysql.user SET Super_Priv='Y', Process_priv='Y' WHERE user='${MYSQL_GALERA_USER}' AND host='localhost';
    FLUSH PRIVILEGES;
EOSQL
}

password_change
unset -f password_change