David Gerard wrote:
IME, the user rights for MediaWiki frequently need bludgeoning. I routinely end up doing (something like):
GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'localhost'; GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiuser'@'%';
- and it seems I need both.
You need the first one because mysql comes with a '%'@'localhost' account which takes precedence to any 'foo'@'%' :(