projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'master' of git.freeside.biz:/home/git/freeside
[freeside.git]
/
rt
/
etc
/
acl.mysql
diff --git
a/rt/etc/acl.mysql
b/rt/etc/acl.mysql
index
0982ca2
..
1688237
100755
(executable)
--- 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";
return;
}
print "Granting access to $db_user\@'$db_rthost' on $db_name.\n";
+ $db_name =~ s/([_%])/\\$1/g;
return (
return (
- "USE mysql;",
- "DELETE FROM user WHERE user = '$db_user';",
- "DELETE FROM db where db = '$db_name';",
"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
"GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE
- ON
$db_name
.*
+ ON
`$db_name`
.*
TO '$db_user'\@'$db_rthost'
IDENTIFIED BY '$db_pass';",
);
TO '$db_user'\@'$db_rthost'
IDENTIFIED BY '$db_pass';",
);