(Fred Bauder fredbaud@ctelco.net): Which mysql privileges should wikiuser have?
How about sysops?
Developers?
The maintenance directory has a script "buildusers.sql" that grants all the needed privileges to users "wikiuser", "wikiadmin", and "wikisql". Developer status is a function of the software and isn't manifested as a different MySQL user.
Bascially, wikiuser can do anything but create and change the database, and most of the normal wiki functions happen as that user. Wikisql is a restricted user that can only select; it is used for the direct SQL query function of Sysops to limit potential damage. Wikiadmin is not used by the software at all, but is used by the build scripts and such. It is meant for those with real access to the server.