aboutsummaryrefslogtreecommitdiff
path: root/docker/galera/config-galera.sh
diff options
context:
space:
mode:
Diffstat (limited to 'docker/galera/config-galera.sh')
-rwxr-xr-xdocker/galera/config-galera.sh37
1 files changed, 37 insertions, 0 deletions
diff --git a/docker/galera/config-galera.sh b/docker/galera/config-galera.sh
new file mode 100755
index 000000000..e66084001
--- /dev/null
+++ b/docker/galera/config-galera.sh
@@ -0,0 +1,37 @@
+#!/bin/bash
+
+function bootstrap_db {
+ mysqld_safe --wsrep-new-cluster &
+
+ # Waiting for deamon
+ sleep 10
+ expect -c '
+ set timeout 10
+ spawn mysql_secure_installation
+ expect "Enter current password for root (enter for none):"
+ send "\r"
+ expect "Set root password?"
+ send "y\r"
+ expect "New password:"
+ send "'"${DB_ROOT_PASSWORD}"'\r"
+ expect "Re-enter new password:"
+ send "'"${DB_ROOT_PASSWORD}"'\r"
+ expect "Remove anonymous users?"
+ send "y\r"
+ expect "Disallow root login remotely?"
+ send "n\r"
+ expect "Remove test database and access to it?"
+ send "y\r"
+ expect "Reload privilege tables now?"
+ send "y\r"
+ expect eof'
+
+ mysql -u root --password="${DB_ROOT_PASSWORD}" -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '${DB_ROOT_PASSWORD}' WITH GRANT OPTION;"
+ mysql -u root --password="${DB_ROOT_PASSWORD}" -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '${DB_ROOT_PASSWORD}' WITH GRANT OPTION;"
+ mysqladmin -p"${DB_ROOT_PASSWORD}" shutdown
+}
+
+function populate_db {
+ mysql_install_db
+ chown -R mysql: /var/lib/mysql
+}