I've just installed MediaWiki on a web server. Obviously it needs lots of privileges during installation to set up its database correctly. Now that it's installed can I safely revoke some privileges (e.g. create table, drop table?) Or might it need to create more tables later (when they are first needed?) If not then I would prefer to grant it as few privileges as possible.
views:
239answers:
2
A:
Change the user that mediawiki connects as in LocalSettings.php and then using phpMyAdmin, you can edit the privileges of that user (that is, if you aren't comfortable granting and revoking privileges from the mysql console).
UltimateBrent
2008-09-19 21:47:41
It already has its own user ('wikiuser'.) What's the advantage of adding another?
finnw
2008-09-19 22:11:15
none, unless you'd used the root user to do it. You can just revoke the privileges for wikiuser with phpMyAdmin and your set.
UltimateBrent
2008-09-19 22:50:33
+2
A:
After the installation, MediaWiki doesn't need to create any more tables. I'd suggest giving the user insert, select, and lock permission.
grant select,lock tables,insert on media_wiki_db.* to 'wiki'@'localhost' identified by 'password';
hoyhoy
2008-09-19 21:51:52