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";
+ RT->Logger->warn("DatabaseUser option is not defined or empty. Skipping...");
return;
}
if ( $db_user eq 'root' ) {
- print STDERR "DatabaseUser is root. Skipping...\n";
+ RT->Logger->warn("DatabaseUser is root. Skipping...");
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';",
);