X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/blobdiff_plain/35659203a708078cdec25ff74adbe1e9168934d6..5ad00addff68d8957629499e019c4a001051aca4:/src/plugins/domtool-mysql diff --git a/src/plugins/domtool-mysql b/src/plugins/domtool-mysql index f476482..4f9c9ce 100755 --- a/src/plugins/domtool-mysql +++ b/src/plugins/domtool-mysql @@ -39,7 +39,16 @@ case $1 in sudo -H mysql -e "GRANT CREATE,SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE VIEW,SHOW VIEW,GRANT OPTION ON TABLE * TO '$USERNAME'@$WHERE;" $DBNAME sudo -H mysql -e "FLUSH PRIVILEGES;" ;; + + dropdb) + USERNAME=$2 + DBNAME_BASE=$3 + DBNAME="${USERNAME}_${DBNAME_BASE}" + + sudo -H mysql -e "DROP DATABASE $DBNAME"; + ;; + *) - echo "Usage: domtool-mysql [adduser | passwd | createdb ]" + echo "Usage: domtool-mysql [adduser | passwd | createdb | dropdb ]" ;; esac