1 files changed, 5 insertions, 22 deletions
diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql
index 16882378e..0ecaa3b15 100755
--- a/rt/etc/acl.mysql
+++ b/rt/etc/acl.mysql
@@ -1,25 +1,8 @@
-
 sub acl {
-    my $db_name = RT->Config->Get('DatabaseName');
-    my $db_rthost = RT->Config->Get('DatabaseRTHost');
-    my $db_user = RT->Config->Get('DatabaseUser');
-    my $db_pass = RT->Config->Get('DatabasePassword');
-    unless ( $db_user ) {
-        print STDERR "DatabaseUser option is not defined or empty. Skipping...\n";
-        return;
-    }
-    if ( $db_user eq 'root' ) {
-        print STDERR "DatabaseUser is root. Skipping...\n";
-        return;
-    }
-    print "Granting access to $db_user\@'$db_rthost' on $db_name.\n";
-    $db_name =~ s/([_%])/\\$1/g;
-    return (
-        "GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
-               ON `$db_name`.*
-               TO '$db_user'\@'$db_rthost'
-               IDENTIFIED BY '$db_pass';",
-    );
+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;