diff options
Diffstat (limited to 'modules/apps/mariadb/default.nix')
-rw-r--r-- | modules/apps/mariadb/default.nix | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/modules/apps/mariadb/default.nix b/modules/apps/mariadb/default.nix index 4574be6..058eaa8 100644 --- a/modules/apps/mariadb/default.nix +++ b/modules/apps/mariadb/default.nix @@ -134,18 +134,22 @@ let mysql_upgrade --user=${cfg.user} mysql_tzinfo_to_sql "$TZDIR" | mysql mysql mysql mysql < ${./procedures.sql} - cat <<'__SQL__' | mysql + + cat <<'__SQL__' | mysql -N mysql | mysql -v mysql + SELECT CONCAT("DROP USER IF EXISTS '", User, "'@'", Host, "';") + FROM user + WHERE User IN ('root', ${"''"}) + OR (User='${cfg.user}' AND Host <> 'localhost') + ; + __SQL__ + + cat <<'__SQL__' | mysql -v mysql DROP DATABASE IF EXISTS test; - DELETE FROM mysql.db WHERE Db='test' OR Db='test%'; - DELETE FROM mysql.user WHERE User='${cfg.user}' AND Host NOT IN ('localhost'); - DELETE FROM mysql.user WHERE User=${"''"}; - DELETE FROM mysql.user WHERE User='root'; - DELETE FROM mysql.proxies_priv WHERE User='root'; - FLUSH PRIVILEGES; ${concatMapStrings (db: '' CREATE DATABASE IF NOT EXISTS `${db}`; '') cfg.databases} __SQL__ + ${optionalString hasMasters "mysql -e 'START ALL SLAVES'"} ''; |