1 files changed, 9 insertions, 0 deletions
diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql
new file mode 100755
index 000000000..621ef121c
--- /dev/null
+++ b/rt/etc/acl.mysql
@@ -0,0 +1,9 @@
+sub acl {
+return () if !$RT::DatabaseUser or $RT::DatabaseUser eq 'root';
+return  (
+"USE mysql;",
+"DELETE FROM user WHERE user = '${RT::DatabaseUser}';",
+"DELETE FROM db where db = '${RT::DatabaseName}';",
+"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON ${RT::DatabaseName}.* TO ${RT::DatabaseUser}\@'${RT::DatabaseRTHost}' IDENTIFIED BY '${RT::DatabasePassword}';");
+}
+1;