Dan Jacobson schrieb:
php rebuildtextindex.php ALTER TABLE... 1142: ALTER command denied to user...
< You do not have the right MySQL permissions. Add to your wikiuser < account the ALTER TABLE privilege and your problems should be fixed.
And indeed they were. Now let's try another script. $ php updateSearchIndex.php LOCK TABLES... 1044: Access denied for user...
And indeed, adding more privileges fixes that too.
My question is why doesn't update.php fix or at least warn about these? E.g., "Bla lacks permissions to do ZZZ. Some maintenance scripts won't run. Some daily tasks will be hindered."
By the way on http://meta.wikimedia.org/wiki/Help:How_to_move_a_wiki_to_another_server "SELECT, INSERT, UPDATE and DELETE permissions should suffice."