diff options
Diffstat (limited to 'rt/etc/acl.mysql')
-rwxr-xr-x | rt/etc/acl.mysql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/rt/etc/acl.mysql b/rt/etc/acl.mysql index 0982ca228..16882378e 100755 --- a/rt/etc/acl.mysql +++ b/rt/etc/acl.mysql @@ -13,12 +13,10 @@ sub acl { return; } print "Granting access to $db_user\@'$db_rthost' on $db_name.\n"; + $db_name =~ s/([_%])/\\$1/g; return ( - "USE mysql;", - "DELETE FROM user WHERE user = '$db_user';", - "DELETE FROM db where db = '$db_name';", "GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE - ON $db_name.* + ON `$db_name`.* TO '$db_user'\@'$db_rthost' IDENTIFIED BY '$db_pass';", ); |