From b15f551485951175fd302661b93f4fcc9e03ac6e Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Thu, 26 Jun 2025 18:10:54 -0400 Subject: [PATCH] Improving Mysql Installation --- support/crdb.sh | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/support/crdb.sh b/support/crdb.sh index f836bae..925ca29 100755 --- a/support/crdb.sh +++ b/support/crdb.sh @@ -47,10 +47,15 @@ case "$DB_TYPE" in if [ "$USER" = "root" ] ; then chown $APPNAME $LOG ( - echo "CREATE DATABASE $APPNAME;" + echo "CREATE USER apache@localhost;" + echo "GRANT USAGE ON $APPNAME.* TO apache@localhost;" + echo "CREATE USER dovecot@localhost;" + echo "GRANT USAGE ON $APPNAME.* TO dovecot@localhost;" + echo "GRANT SELECT ON $APPNAME.* TO dovecot@localhost;" echo "CREATE USER $APPNAME@localhost;" echo "GRANT ALL PRIVILEGES ON $APPNAME.* TO $APPNAME@localhost;" echo "FLUSH PRIVILEGES;" + echo "CREATE DATABASE $APPNAME;" ) | $SQL >> $LOG /bin/echo "data-base is now created" >> $LOG fi -- 2.47.3