From 4a54bdb375ccfa51d348a0f34f110e580e669e9b Mon Sep 17 00:00:00 2001 From: Erik Moeller Date: Sun, 18 Jan 2004 21:10:07 +0000 Subject: [PATCH] some necessary escaping for table names --- maintenance/database.sql | 4 +- maintenance/users.sql | 96 ++++++++++++++++++++-------------------- 2 files changed, 50 insertions(+), 50 deletions(-) diff --git a/maintenance/database.sql b/maintenance/database.sql index 812156e6b1..dea9954248 100644 --- a/maintenance/database.sql +++ b/maintenance/database.sql @@ -3,5 +3,5 @@ -- their values from local settings. -- -DROP DATABASE IF EXISTS {$wgDBname}; -CREATE DATABASE {$wgDBname}; +DROP DATABASE IF EXISTS `{$wgDBname}`; +CREATE DATABASE `{$wgDBname}`; diff --git a/maintenance/users.sql b/maintenance/users.sql index fb1396b613..0c2ce7c1b1 100644 --- a/maintenance/users.sql +++ b/maintenance/users.sql @@ -4,106 +4,106 @@ -- from local settings. -- -GRANT ALL ON {$wgDBname}.* +GRANT ALL ON `{$wgDBname}`.* TO {$wgDBadminuser}@'%' IDENTIFIED BY '{$wgDBadminpassword}'; -GRANT ALL ON {$wgDBname}.* +GRANT ALL ON `{$wgDBname}`.* TO {$wgDBadminuser}@localhost IDENTIFIED BY '{$wgDBadminpassword}'; -GRANT ALL ON {$wgDBname}.* +GRANT ALL ON `{$wgDBname}`.* TO {$wgDBadminuser}@localhost.localdomain IDENTIFIED BY '{$wgDBadminpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname}.* +GRANT DELETE,INSERT,SELECT,UPDATE ON `{$wgDBname}`.* TO {$wgDBuser}@'%' IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname}.* +GRANT DELETE,INSERT,SELECT,UPDATE ON `{$wgDBname}`.* TO {$wgDBuser}@localhost IDENTIFIED BY '{$wgDBpassword}'; -GRANT DELETE,INSERT,SELECT,UPDATE ON {$wgDBname}.* +GRANT DELETE,INSERT,SELECT,UPDATE ON `{$wgDBname}`.* TO {$wgDBuser}@localhost.localdomain IDENTIFIED BY '{$wgDBpassword}'; -GRANT SELECT (user_id,user_name,user_rights,user_options) ON {$wgDBname}.user +GRANT SELECT (user_id,user_name,user_rights,user_options) ON `{$wgDBname}`.user TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.cur +GRANT SELECT ON `{$wgDBname}`.cur TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.old +GRANT SELECT ON `{$wgDBname}`.old TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.archive +GRANT SELECT ON `{$wgDBname}`.archive TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.links +GRANT SELECT ON `{$wgDBname}`.links TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.brokenlinks +GRANT SELECT ON `{$wgDBname}`.brokenlinks TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.imagelinks +GRANT SELECT ON `{$wgDBname}`.imagelinks TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.site_stats +GRANT SELECT ON `{$wgDBname}`.site_stats TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.ipblocks +GRANT SELECT ON `{$wgDBname}`.ipblocks TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.image +GRANT SELECT ON `{$wgDBname}`.image TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.oldimage +GRANT SELECT ON `{$wgDBname}`.oldimage TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.recentchanges +GRANT SELECT ON `{$wgDBname}`.recentchanges TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.watchlist +GRANT SELECT ON `{$wgDBname}`.watchlist TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.math +GRANT SELECT ON `{$wgDBname}`.math TO {$wgDBsqluser}@'%' IDENTIFIED BY '{$wgDBsqlpassword}'; GRANT SELECT (user_id,user_name,user_rights,user_options) - ON {$wgDBname}.user + ON `{$wgDBname}`.user TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.cur +GRANT SELECT ON `{$wgDBname}`.cur TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.old +GRANT SELECT ON `{$wgDBname}`.old TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.archive +GRANT SELECT ON `{$wgDBname}`.archive TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.links +GRANT SELECT ON `{$wgDBname}`.links TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.brokenlinks +GRANT SELECT ON `{$wgDBname}`.brokenlinks TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.imagelinks +GRANT SELECT ON `{$wgDBname}`.imagelinks TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.site_stats +GRANT SELECT ON `{$wgDBname}`.site_stats TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.ipblocks +GRANT SELECT ON `{$wgDBname}`.ipblocks TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.image +GRANT SELECT ON `{$wgDBname}`.image TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.oldimage +GRANT SELECT ON `{$wgDBname}`.oldimage TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.recentchanges +GRANT SELECT ON `{$wgDBname}`.recentchanges TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.watchlist +GRANT SELECT ON `{$wgDBname}`.watchlist TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.math +GRANT SELECT ON `{$wgDBname}`.math TO {$wgDBsqluser}@localhost IDENTIFIED BY '{$wgDBsqlpassword}'; GRANT SELECT (user_id,user_name,user_rights,user_options) - ON {$wgDBname}.user + ON `{$wgDBname}`.user TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.cur +GRANT SELECT ON `{$wgDBname}`.cur TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.old +GRANT SELECT ON `{$wgDBname}`.old TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.archive +GRANT SELECT ON `{$wgDBname}`.archive TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.links +GRANT SELECT ON `{$wgDBname}`.links TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.brokenlinks +GRANT SELECT ON `{$wgDBname}`.brokenlinks TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.imagelinks +GRANT SELECT ON `{$wgDBname}`.imagelinks TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.site_stats +GRANT SELECT ON `{$wgDBname}`.site_stats TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.ipblocks +GRANT SELECT ON `{$wgDBname}`.ipblocks TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.image +GRANT SELECT ON `{$wgDBname}`.image TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.oldimage +GRANT SELECT ON `{$wgDBname}`.oldimage TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.recentchanges +GRANT SELECT ON `{$wgDBname}`.recentchanges TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.watchlist +GRANT SELECT ON `{$wgDBname}`.watchlist TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -GRANT SELECT ON {$wgDBname}.math +GRANT SELECT ON `{$wgDBname}`.math TO {$wgDBsqluser}@localhost.localdomain IDENTIFIED BY '{$wgDBsqlpassword}'; -- 2.20.1