summaryrefslogtreecommitdiffstats
path: root/mysql/root-galera/usr/share/container-scripts/mysql/init/50-galera-passwd-change.sh
blob: 5789bdec1c5c84e73a0b0eba6efb6804ad362c08 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#!/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
}

if [ -v MYSQL_GALERA_USER -a -v MYSQL_GALERA_PASSWORD ]; then
    password_change
fi

unset -f password_change